PgSql

Sort of a planner regression 8.3->8.4 (due to EXISTS inlining) and related stuff
On Monday 17 May 2010 04:10:46 Tom Lane wrote: Robert Haas <robertmhaas(a)gmail.com> writes: I believe this is a result of a limitation we've discussed previously, namely, that the planner presently uses a limited, special-case kludge to consider partial index scans, and the executor uses another ... 17 May 2010 00:31

pg_upgrade and extra_float_digits
Bruce Momjian wrote: FYI, I test pg_upgrade by loading the old cluster's regression database from a pg_dump output file, then after the upgrade, I dump the regression database of the new cluster and diff the changes. The problem I just encountered is that pg_dump uses extra_float_digits=-3 for 9.0... 18 May 2010 00:34

Unexpected page allocation behavior on insert-onlytables
On 16.05.2010 02:16, Tom Lane wrote: Michael Renner<michael.renner(a)amd.co.at> writes: I've written a simple tool to generate traffic on a database [1], which did about 30 TX/inserts per second to a table. Upon inspecting the data in the table, I noticed the expected grouping of tuples which came from ... 15 May 2010 21:22

Unexpected page allocation behavior on insert-only tables
Michael Renner <michael.renner(a)amd.co.at> writes: I've written a simple tool to generate traffic on a database [1], which did about 30 TX/inserts per second to a table. Upon inspecting the data in the table, I noticed the expected grouping of tuples which came from a single backend to matching pages [2].... 31 May 2010 17:29

Keepalive for max_standby_delay
Simon Riggs <simon(a)2ndQuadrant.com> writes: Patch adds a keepalive message to ensure max_standby_delay is useful. The proposed placement of the keepalive-send is about the worst it could possibly be. It needs to be done right before pq_flush to ensure minimum transfer delay. Otherwise any attempt to measure c... 3 Jul 2010 15:41

[HACKERS] Keepalive for max_standby_delay
Patch adds a keepalive message to ensure max_standby_delay is useful. No WAL format changes, no libpq changes. Just an additional message type for the streaming replication protocol, sent once per main loop in WALsender. Plus docs. Comments? -- Simon Riggs www.2ndQuadrant.com ... 15 May 2010 09:21

predefined macros for various BSD-based systems?
On Sat, May 15, 2010 at 12:15 AM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: I'm not even too sure what "bsdi" is, but I'm suspicious of that branch too.  A search of our code finds It's a commercial distribution of BSD. I remember it being pretty nice when I used it 10+ years ago, but it sounds like it's dead now.... 15 May 2010 07:13

[HACKERS] predefined macros for various BSD-based systems?
The recently added contrib/pg_upgrade code contains this bit: /* * scandir() is originally from BSD 4.3, which had the third argument as * non-const. Linux and other C libraries have updated it to use a const. * http://unix.derkeiler.com/Mailing-Lists/FreeBSD/questions/2005-12/msg00214.html ... 15 May 2010 00:49

underscore split to alias
"Erik Rijkers" <er(a)xs4all.nl> writes: I am not sure this is a bug, but I was surprised by the following behaviour in HEAD and 8.4.4 (instances built today, 2010.05.14): Invalid (?) values like 123_456 are split before the underscore and interpreted as 123 as "456": All versions of postgres will parse 1... 14 May 2010 19:25

[HACKERS] underscore split to alias
I am not sure this is a bug, but I was surprised by the following behaviour in HEAD and 8.4.4 (instances built today, 2010.05.14): Invalid (?) values like 123_456 are split before the underscore and interpreted as 123 as "456": $ psql -p 6591 -d testdb -c "select 123_456, current_setting('server_version')" ... 14 May 2010 19:25