Re: [PATCHES] Improvement of procArray.xmin for VACUUM

2007-03-24 Thread Heikki Linnakangas
Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: I have been thinking we could improve how quickly VACUUM can expire rows if we update procArray.xmin more frequently for non-SERIALIZABLE transactions. The attached patch updates procArray.xmin in this manner. This

Re: [PATCHES] Improvement of procArray.xmin for VACUUM

2007-03-24 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > It seems to me a lot cleaner to do the reference counting like Tom > suggested. Increase the refcount on CopySnapshot, and decrease it on > FreeSnapshot. Assuming that all callers of CopySnapshot free the > snapshot with FreeSnapshot when they're

Re: [PATCHES] Improvement of procArray.xmin for VACUUM

2007-03-24 Thread Bruce Momjian
Tom Lane wrote: > Heikki Linnakangas <[EMAIL PROTECTED]> writes: > > It seems to me a lot cleaner to do the reference counting like Tom > > suggested. Increase the refcount on CopySnapshot, and decrease it on > > FreeSnapshot. Assuming that all callers of CopySnapshot free the > > snapshot with

Re: [PATCHES] [BUGS] BUG #3095: LDAP authentication parsing incorrectly

2007-03-24 Thread Bruce Momjian
I have researched this problem, and the incorrect behavior seems to be totally caused by the fact that unquoted commas are treated as item separators in pg_hba.conf. I have updated the documentation in 8.2 and CVS HEAD to indicate that the LDAP URL should be double-quoted, and double-quoted the e

Re: [PATCHES] Improvement of procArray.xmin for VACUUM

2007-03-24 Thread Gregory Stark
> OTOH, do we have any evidence that this is worth bothering with at all? > I fear that the cases of long-running transactions that are problems > in the real world wouldn't be helped much --- for instance, pg_dump > wouldn't change behavior because it uses a serializable transaction. Well I think

Re: [PATCHES] LIMIT/SORT optimization

2007-03-24 Thread Gregory Stark
>> Did Greg push a version which didn't carry the "WIP" label to it? As >> far as I remember he was still asking how to make the Sort and Limit >> nodes communicate. > > Good question. I asked for a new version of this patch and the WIP was > only in the email subject line. Greg, is this ready fo

Re: [PATCHES] LIMIT/SORT optimization

2007-03-24 Thread Bruce Momjian
Gregory Stark wrote: > >> Did Greg push a version which didn't carry the "WIP" label to it? As > >> far as I remember he was still asking how to make the Sort and Limit > >> nodes communicate. > > > > Good question. I asked for a new version of this patch and the WIP was > > only in the email sub

Re: [PATCHES] Automatic adjustment of bgwriter_lru_maxpages

2007-03-24 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT

Re: [PATCHES] Optimized pgbench for 8.3

2007-03-24 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT

Re: [PATCHES] POSIX Shared memory, revised, again

2007-03-24 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Ch

Re: [PATCHES] POSIX shared memory support

2007-03-24 Thread Bruce Momjian
Newest version added: Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. -

Re: [PATCHES] Load distributed checkpoint V3

2007-03-24 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT