PgSql

Postgres as Historian
On Mon, Aug 2, 2010 at 3:20 AM, Hardik Belani <hardikbelani(a)gmail.com> wrote: We are using postgres as RDBMS for our product. There is a requirement coming for a feature which will require me to store data about various data points (mainly numbers) on a time scale. Data measurement is being taken every few ... 4 Aug 2010 03:51

(9.1) btree_gist support for searching on "notequals"
On Sun, 2010-08-01 at 21:57 -0400, Robert Haas wrote: On Fri, Jul 16, 2010 at 1:19 AM, Jeff Davis <pgsql(a)j-davis.com> wrote: Thank you for the review. On Mon, 2010-07-12 at 17:17 +0900, Itagaki Takahiro wrote: (1) Exclusion constraints support for operators where "x <operator> x" is false ... 3 Aug 2010 02:45

[HACKERS] Postgres as Historian
We are using postgres as RDBMS for our product. There is a requirement coming for a feature which will require me to store data about various data points (mainly numbers) on a time scale. Data measurement is being taken every few secs/mins based and it is needed to be stored for statistical analysis. Now this requi... 2 Aug 2010 05:59

Initial review of xslt with no limits patch
Hello 2010/8/2 Mike Fowler <mike(a)mlfowler.com>: Hi Pavel, Currently your patch isn't applying to head, from the looks of things a function signature has changed. Can you update your patch please? yes - see attachment Also, having had a read through the patch itself I note that there are no ... 6 Aug 2010 13:47

english parser in text search: support for multiplewords in the same position
Hi, On 08/01/2010 08:04 PM, Sushant Sinha wrote: 1. We do not have separate tokens "wikipedia" and "org" 2. If we have the two tokens we should have them at adjacent position so that a phrase search for "wikipedia org" should work. This would needlessly increase the number of tokens. Instead you'd bett... 2 Aug 2010 13:39

Compiling CVS HEAD with clang under OSX
Neil Conway <neil.conway(a)gmail.com> writes: I tried $subject recently, and noticed some minor issues: (1) Two warnings that suggest bugs; in src/backend/utils/adt, datetime.c:3101:27: warning: use of logical || with constant operand; switch to bitwise | or remove constant And similarly for src/interf... 3 Aug 2010 16:57

[HACKERS] Compiling CVS HEAD with clang under OSX
I tried $subject recently, and noticed some minor issues: (1) Two warnings that suggest bugs; in src/backend/utils/adt, datetime.c:3101:27: warning: use of logical || with constant operand; switch to bitwise | or remove constant And similarly for src/interfaces/ecpg/pgtypeslib/interval.c. Attached is a patch... 1 Aug 2010 20:17

[HACKERS] Initial review of xslt with no limits patch
Hi Pavel, Currently your patch isn't applying to head, from the looks of things a function signature has changed. Can you update your patch please? Also, having had a read through the patch itself I note that there are no tests and no changes to documentation. Shouldn't the documentation advertise that the ... 1 Aug 2010 18:06

[HACKERS] english parser in text search: support for multiple words in thesame position
Currently the english parser in text search does not support multiple words in the same position. Consider a word "wikipedia.org". The text search would return a single token "wikipedia.org". However if someone searches for "wikipedia org" then there will not be a match. There are two problems here: 1. We do not... 1 Aug 2010 14:50

More fun with GIN lossy-page pointers
Excerpts from Tom Lane's message of sáb jul 31 09:57:13 -0400 2010: So far as I can see, it's impossible to handle this situation when examining only one TID per stream with no lookahead. Choosing to advance the second stream would obviously fail in many other cases, so there is no correct action. The o... 1 Aug 2010 11:35