Re: [PATCHES] Autovacuum cancellation

2007-10-27 Thread Simon Riggs
On Fri, 2007-10-26 at 17:50 -0300, Alvaro Herrera wrote: > Ok, committed; I snuck that in as well, but I'm not sure how to test > that it works. I've had time to review that now. I didn't reply to your original post because you'd taken my name off the copy list for some reason and I've been too b

Re: [PATCHES] Autovacuum cancellation

2007-10-27 Thread Simon Riggs
On Fri, 2007-10-26 at 10:32 +0100, Heikki Linnakangas wrote: > Alvaro Herrera wrote: > > /* > > * Look for a blocking autovacuum. There will only ever > > * be one, since the autovacuum workers are careful > > * not to operate concurrently on the same table. > > */ > > I think that's a bit un

Re: [PATCHES] Autovacuum cancellation

2007-10-27 Thread Simon Riggs
On Thu, 2007-10-25 at 17:35 -0400, Tom Lane wrote: > There's some things still to be desired here: if an autovac process is > involved in a hard deadlock, the patch doesn't favor zapping it over > anybody else, nor consider cancelling the autovac as an alternative to > rearranging queues for a soft

[PATCHES] updated hash functions for postgresql v1

2007-10-27 Thread Kenneth Marshall
Dear PostgreSQL Developers, This patch is a "diff -c" against the hashfunc.c from postgresql-8.3beta1. It implements the 2006 version of the hash function by Bob Jenkins. Its features include a better and faster hash function. I have included the versions supporting big-endian and little-endian ma

Re: [PATCHES] Minor change to pg_dump docs

2007-10-27 Thread Bruce Momjian
Chris Browne wrote: > As suggested to me by Ian Darwin <[EMAIL PROTECTED]>... > > Index: doc/src/sgml/ref/pg_dump.sgml > === > RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v > retrieving revision 1.97 > diff -c -u -