PgSql
in [SQL]
|
[HACKERS] streaming replication breaks horribly if master crashes On Mon, Jun 14, 2010 at 7:55 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: But that change would cause the problem that Robert pointed out. http://archives.postgresql.org/pgsql-hackers/2010-06/msg00670.php Presumably this means that if synchronous_commit = off on primary that SR in 9.0 will no longer ... 16 Jun 2010 16:36
9.0 beta2 pg_upgrade: malloc 0 bytes patch Steve Singer wrote: Running pg_upgrade against an unmodified (the output of initdb) cluster on AIX is giving me "pg_alloc: Out of memory" errors. On some non-linux platforms (including AIX) malloc(0) returns 0. with the attached patch to pg_upgrade I am now able to get pg_upgrade to conver... 16 Jun 2010 16:36
Patch to show individual statement latencies in pgbench output On Jun 14, 2010, at 2:22 , Greg Smith wrote: Florian Pflug wrote: To be able to asses the performance characteristics of the different wal-related options, I patched pgbench to show the average latency of each individual statement. The idea is to be able to compare the latency of the COMMIT with the ones of the ... 16 Jun 2010 15:29
GetOldestWALSendPointer() in header Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> writes: GetOldestWALSendPointer() is commented out in the source code with NOT_USED block, but is still declared in the header file. Should we remove the function prototype from walsender.h ? Yes, that's our usual convention. regards, tom lane -- ... 16 Jun 2010 15:28
PL/Perl function naming Tim Bunce wrote: If the "feature" is not any use should we rip it out? We pretty much included it because you said it was what you needed for the profiler. Yes, it can go. Done. cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql... 16 Jun 2010 15:28
Add a new backend process On Jun 16, 2010, at 8:47 , Amir Abdollahi wrote: I want to add a new backend process to postgres, to include my own auditing modules. How can i do that, also how can i signal it after! The existing auxiliary processes (in 8.4) and their entry points are autovacuum (autovacuum.c, AutoVacLauncherMain) bgwrite... 16 Jun 2010 07:46
[v9.1] Add security hook on initialization of instance (2010/06/15 21:37), Stephen Frost wrote: KaiGai, * KaiGai Kohei (kaigai(a)ak.jp.nec.com) wrote: In the attached patch, the security hook was moved to ClientAuthentication() from InitPostgres(), for more clarification of the purpose. What I want to do is to assign additional properties to identify th... 12 Jul 2010 04:10
debug log in pg_archivecleanup Fujii Masao <masao.fujii(a)gmail.com> wrote: This is because pg_archivecleanup puts the line break "\n" in the head of debug message. Why should we do so? ----------------------- if (debug) fprintf(stderr, "\n%s: removing \"%s\"", progname, WALFilePath); ----------------------- We also ... 18 Jun 2010 11:19
to enable O_DIRECT within postgresql Daniel Ng <danielng1985(a)gmail.com> writes: I am trying to enable the direct IO for the disk-resident hash partitions of hashjoin in postgresql. Why would you think that's a good idea? Can anyone advise what's the reason and how to fix this? Per the open(2) man page: The O_DIRECT flag m... 20 Jun 2010 08:02
[HACKERS] to enable O_DIRECT within postgresql Dear all, I am trying to enable the direct IO for the disk-resident hash partitions of hashjoin in postgresql. The basic postgres environment settings are: centos 5.5 kernel 2.6.18 ext3 fs PostgreSQL 8.4.3 Previously I added the O_DIRECT flag to the "fileFlags" param... 15 Jun 2010 23:07 |