PgSql

pgsql: Check compulsory parameters in recovery.conf in standby_mode, per
Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> writes: Well, it would still be useful, as it would shorten the delay. But yeah, there's a delay in asynchronous replication anyway, so we decided to keep it simple and just poll. It's not ideal and definitely needs to be revisited for synchronous mod... 6 Apr 2010 14:10

SELECT constant; takes 15x longer on 9.0?
Josh Berkus <josh(a)agliodbs.com> wrote: SELECT 'DBD::Pg ping test'; In our test, which does 5801 of these pings during the test, they take an average of 15x longer to execute on 9.0 as 8.4 ( 0.77ms vs. 0.05ms ). Any clue why this would be? Did you use the same configure options between them? ... 7 Apr 2010 02:25

Remaining Streaming Replication Open Items
On Tue, Apr 6, 2010 at 4:09 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: I triaged the list of open items on the Streaming Replication wiki page. I propose that we drop the ones I've marked as Drop below, and move the remaining items to the main Open Items page for better visibility. An... 16 Apr 2010 06:10

[HACKERS] Hot Standby: Startup at shutdown checkpoint
Initial patch. I will be testing over next day. No commit before at least midday on Wed 7 Apr. The existing call to PrescanPreparedTransactions() looks correct to me but the comment is wrong. I will change that also, if we agree. -- Simon Riggs www.2ndQuadrant.com ... 6 Apr 2010 06:23

Question about WAL and XID
Boszormenyi Zoltan wrote: am I right that an XID is global across the whole DB cluster under the same $PGDATA? Yes. I am asking this because I need to check TransactionIdDidCommit(XLogRecord->xl_xid) from the walreciver. Can I expect it to work on any xl_xid that walreceiver encounters? Wa... 6 Apr 2010 05:18

[HACKERS] Question about WAL and XID
Hi, am I right that an XID is global across the whole DB cluster under the same $PGDATA? I am asking because in the WAL record, the first thing sent is an XLogRecord which contains TransactionId xl_xid; and as the comment in access/xlog.h says: /* * The overall layout of an XLOG record is: * ... 6 Apr 2010 05:18

Quoting in recovery.conf
On Tue, Apr 6, 2010 at 3:47 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: To follow up on the discussion here: http://archives.postgresql.org/pgsql-docs/2010-02/msg00039.php It seems like a big oversight that there's no way to insert quotes in strings in recovery.conf. In the lo... 7 Apr 2010 07:51

[HACKERS] Quoting in recovery.conf
To follow up on the discussion here: http://archives.postgresql.org/pgsql-docs/2010-02/msg00039.php It seems like a big oversight that there's no way to insert quotes in strings in recovery.conf. In the long run, the parsing should be done the same way as postgresql.conf, or the two files be merged altogether, ... 6 Apr 2010 03:10

Prepared query parsing much slower in 9.0?
Hackers, Followup to Josh's posts. I'm getting Bricolage 2.0 ready to ship, and took some time to test it on PostgreSQL 9.0 today. I built PostgreSQL from Git/master with: ./configure --with-libs=/usr/local/lib --with-includes=/usr/local/include --prefix=$BASE --with-perl PERL=$PERL This is simpler ... 6 Apr 2010 14:10

[HACKERS] SELECT constant; takes 15x longer on 9.0?
Hackers, Continuing the performance test: DBD, like a number of monitoring systems, does "pings" on the database which look like this: SELECT 'DBD::Pg ping test'; In our test, which does 5801 of these pings during the test, they take an average of 15x longer to execute on 9.0 as 8.4 ( 0.77ms vs. 0.05ms ).... 6 Apr 2010 02:05