Re: vacuumlo patch - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: vacuumlo patch
Date
Msg-id 1311559631-sup-8680@alvh.no-ip.org
Whole thread Raw
In response to vacuumlo patch  (Tim <elatllat@gmail.com>)
Responses Re: vacuumlo patch
List pgsql-hackers
Excerpts from Tim's message of dom jul 24 14:48:08 -0400 2011:
> Please consider adding this minor patch, or offering improvements.
> 
> *Problem*: vacuumlo required PostgreSQL to use more locks per transaction
> than possible resulting in an error and a log file full of "ignored until
> end of transaction" warnings.
> (max_locks_per_transaction is limited by shmmax which is limited by RAM)

Interesting.  I cannot vouch for or against the patch, but please
resubmit without the -U0 switch.


-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: libpq SSL with non-blocking sockets
Next
From: Alvaro Herrera
Date:
Subject: Re: Policy on pulling in code from other projects?