PgSql

pgsql: Make standby server continuouslyretry restoring the next WAL
Tom Lane wrote: Fujii Masao <masao.fujii(a)gmail.com> writes: OK. How about making the startup process emit WARNING, stop WAL replay and wait for the presence of trigger file, when an invalid record is found? Which keeps the server up for readonly queries. And if the trigger file is found, I think that... 25 Mar 2010 06:52

Performance Improvement for Unique Indexes
Gokulakannan Somasundaram <gokul007(a)gmail.com> writes: While i was studying the unique index checks very closely, i realized that what we need is to find out whether the tuple is deleted / not. So say a tuple is deleted by a transaction, but it is not dead( because of some long running transaction ), sti... 24 Mar 2010 12:20

Mismatch in libpqwalreceiver
On Wed, Mar 24, 2010 at 1:49 AM, Hitoshi Harada <umi.tanuki(a)gmail.com> wrote: There's a mismatch in HEAD between README and the actual definition in replication/libpqwalreceiver. In README, bool walrcv_receive(int timeout, XLogRecPtr *recptr, char **buffer, int *len) but in walreceiver.h, ... 23 Mar 2010 21:45

booleans in recovery.conf
On Wed, Mar 24, 2010 at 8:43 AM, Bruce Momjian <bruce(a)momjian.us> wrote: Is there a reason that recovery.conf uses true/false, while postgresql.conf uses on/off? IIRC, because, in the old version, recovery.conf allowed only true/false as a boolean value. Of course, we can change those now. Regards, -- ... 31 Mar 2010 10:58

[HACKERS] booleans in recovery.conf
Is there a reason that recovery.conf uses true/false, while postgresql.conf uses on/off? #recovery_target_inclusive = 'true' # 'true' or 'false' or are these settings more boolean for some reason? -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB ... 23 Mar 2010 20:37

[HACKERS] Mismatch in libpqwalreceiver
There's a mismatch in HEAD between README and the actual definition in replication/libpqwalreceiver. In README, bool walrcv_receive(int timeout, XLogRecPtr *recptr, char **buffer, int *len) but in walreceiver.h, typedef bool (*walrcv_receive_type) (int timeout, unsigned char *type, char **buf... 23 Mar 2010 13:39

[HACKERS] Opa
http://sites.google.com/site/aoifsgdf/fxjn5n _________________________________________________________________ Take your contacts everywhere http://go.microsoft.com/?linkid=9712959... 23 Mar 2010 12:28

Windowing Qual Pushdown
2010/3/21 Daniel Farina <drfarina(a)acm.org>: In the function "subquery_is_pushdown_safe", there is an immediate "false" returned if the subquery has a windowing function.  While that seems true in general, are there cases where we can push down a qual if it is on the partitioning key?  Or do NULLs or some ot... 23 Mar 2010 13:39

Standalone backends run StartupXLOG in an incorrect environment
Bruce Momjian <bruce(a)momjian.us> writes: [This is an open item for 9.0, hence the response to an apparently old hackers thread] Thanks for the reply; 9.0 open item removed. I think you misread his reply. Please put that back. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-h... 20 Apr 2010 18:31

Standalone backends run StartupXLOG in anincorrect environment
Simon Riggs wrote: On Sat, 2009-09-19 at 13:21 -0400, Tom Lane wrote: I realized the truth of $SUBJECT while reading this report: http://archives.postgresql.org/pgsql-general/2009-09/msg00712.php ... Also, does this have any impact on the Hot Standby stuff? It could potentially, but ... 22 Mar 2010 21:49