PgSql

CVS corruption/mistagging?
Looking into recent buildfarm failures on the 7.4 branch: http://www.pgbuildfarm.org/cgi-bin/show_status.pl It looks like parts of the CVS repository have been mistagged as belonging to REL7_4_STABLE or have been corrupted somehow: http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_b... 15 Aug 2007 15:22

Bug: Buffer cache is not scan resistant
I'm putting this out there before we publish a fix so that we can discuss how best to fix it. Doug and Sherry recently found the source of an important performance issue with the Postgres shared buffer cache. The issue is summarized like this: the buffer cache in PGSQL is not "scan resistant" as advertised. A... 2 Apr 2007 19:28

xlogViewer / xlogdump
Hi Does anyone has an idea how xlogdump works with Windows installation of Postgres. I have postgres 8.2.x installed on my windows PC. How do we install it on Linux box with existing postgres 8.2.x installation Thanks Vishal _________________________________________________________________ Find a l... 2 Mar 2007 09:12

Implicit casts with generic arrays
I've looked into cutting back on the implicit casts to text, which exposed the following little gem. The expressions 'abc' || 34 34 || 'abc' would no longer work, with the following error message: ERROR: 22P02: array value must start with "{" or dimension information That's because the best matches a... 28 Feb 2007 08:25

pg_proc without oid?
I notice that this patch: http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.443&r2=1.444 inserts a bunch of XML related rows in pg_proc without specifying oid. This breaks the fmgrtab generator on msvc. Most likely because I didn't think of that case. But since all other ro... 21 Feb 2007 08:01

New feature request: FlashBack Query
PostgreSQL, already a mature database, needs to have more options for recovery as compared to proprietary databases. I just worked with Oracle's FlashBack query feature in Oracle 9i and FlashBack Table feature in 10g. Future versions of PostgreSQL must have similar features which enable users to bring Table(s) ... 1 Mar 2007 13:06

Piggybacking vacuum I/O
I've been looking at the way we do vacuums. The fundamental performance issue is that a vacuum generates nheapblocks+nindexblocks+ndirtyblocks I/Os. Vacuum cost delay helps to spread the cost like part payment, but the total is the same. In an I/O bound system, the extra I/O directly leads to less throughput. ... 26 Jan 2007 22:01

Replication documentation addition
Please disregard. I am redoing it and will post a URL with the most recent version. --------------------------------------------------------------------------- Bruce Momjian wrote: Here is my first draft of a new replication section for our documentation. I am looking for any comments. -----... 27 Oct 2006 16:14

Lock partitions
I see this in the CVS commits for 8.2. Did we determine the proper number of lock partitions? Should it be based on the number of buffers or concurrent sessions allowed? Divide the lock manager's shared state into 'partitions', so as to reduce contention for the former single LockMgrLock. Per my recent pro... 18 Oct 2006 13:43

PANIC: could not locate a valid checkpoint record
Other than backing up $PGDATA and running pg_resetxlog Is there any advice ? Dave Nov 16 18:03:30 dx1-ptr postgres[22337]: [6-2] '2005-11-16 17:47:31' Nov 16 18:03:32 dx1-ptr postgres[29335]: [2-1] LOG: received fast shutdown request Nov 16 18:03:32 dx1-ptr postgres[29335]: [3-1] LOG: aborting any ... 16 Nov 2005 16:50