PgSql

Choosing between seqscan and bitmap scan
Oleg Bartunov <oleg(a)sai.msu.su> writes: On Thu, 29 Apr 2010, Tom Lane wrote: There's a fuzz factor of (IIRC) 1% in path cost comparisons. It's deciding that the seqscan and bitmapscan total costs are not meaningfully different; then since the startup costs *are* meaningfully different, it's making t... 29 Apr 2010 11:14

XML Todo List
On ons, 2010-04-28 at 15:21 +0100, Mike Fowler wrote: xpath_exists() is needed. It checks, whether or not the path specified exists in the XML value. (W/o this function we need to use weird "array_dims(xpath(...)) IS NOT NULL" syntax.) That sounds like a reasonable project. Is any one else working on... 29 Apr 2010 05:40

pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS]pgsql: Make CheckRequiredParameterValues() depend upon correct
Aidan Van Dyk wrote: I remember a presentation at pgcon a while ago, it was probaly Fujii (from NTT?) about their log streaming, and at that time, they talked about different "sync" options... It's all outlined at http://wiki.postgresql.org/wiki/Streaming_Replication#Synchronization_capability -- Gre... 28 Apr 2010 21:59

pg_start_backup and pg_stop_backup Re: [HACKERS] Re:[COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend uponcorrect
* Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> [100428 14:49]: You'd need a stand-alone tool to do the streaming in that case, and no such tool exists yet, but I would be surprised if one doesn't appear on pgfoundry sooner or later :-). And this tool is something I will eventually be interest... 31 May 2010 15:17

explicit (void *) casts
"Kevin Grittner" <Kevin.Grittner(a)wicourts.gov> writes: I'm wondering the reason that I see (void *) casts for function call parameters which are pointers to specific structures. Do some compilers generate warnings if these are omitted? There are some places where we do that to suppress warnings, yes. Any ... 28 Apr 2010 15:10

pg_start_backup and pg_stop_backup Re: [HACKERS] Re:[COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct
On Wed, 2010-04-28 at 11:11 -0700, Josh Berkus wrote: IOW I think that the requirement in pg_start_backup shouldn't be relaxed without some more thought/work. Yeah, I was talking to Bruce about that this AM, and it seems like a feature we *need* to have ... for 9.1. I'm sufficiently concerned... 30 Apr 2010 15:09

[HACKERS] bug in build_startup_packet()
Hi, We seem to have forgotten to give conn->replication "[0]". diff --git a/src/interfaces/libpq/fe-protocol3.c b/src/interfaces/libpq/fe-protocol3.c index 77cee8a..1956f00 100644 --- a/src/interfaces/libpq/fe-protocol3.c +++ b/src/interfaces/libpq/fe-protocol3.c @@ -1909,7 +1909,7 @@ build_startup_packet(co... 28 Apr 2010 09:28

pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct
Robert Haas wrote: On Wed, Apr 28, 2010 at 6:52 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: On Wed, 2010-04-28 at 19:40 +0900, Fujii Masao wrote: On Wed, Apr 28, 2010 at 4:43 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: This doesn't contain any changes to pg_start_backup... 30 Apr 2010 15:09

pg_start_backup and pg_stop_backup Re: [HACKERS] Re:[COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct
On Wed, 2010-04-28 at 19:40 +0900, Fujii Masao wrote: On Wed, Apr 28, 2010 at 4:43 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: This doesn't contain any changes to pg_start_backup() yet, that's a separate issue and still under discussion. I'm thinking of changing pg_start_b... 9 May 2010 15:25

pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct
On Wed, Apr 28, 2010 at 4:43 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: This doesn't contain any changes to pg_start_backup() yet, that's a separate issue and still under discussion. I'm thinking of changing pg_start_backup and pg_stop_backup so that they just check that wal_level >=... 9 May 2010 00:21