Re: Autovacuum and pg_largeobject - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Autovacuum and pg_largeobject
Date
Msg-id 1278113349-sup-926@alvh.no-ip.org
Whole thread Raw
In response to Re: Autovacuum and pg_largeobject  (Norberto Delle <betodelle@gmail.com>)
List pgsql-general
Excerpts from Norberto Delle's message of vie jul 02 13:43:37 -0400 2010:

> As far as I know, It's not being locked. We use it to store digitalized
> documents
> and it's getting very big. I think the server is being turned off before
> it can complete
> an vacuum pass. The server is not kept on overnight.

Oh.  That's exceptional.  I think you'd be better served by scheduling a
manual vacuum sometime during the day -- and probably with lower
cost_delay parameters, so that it takes less time to complete.

pgsql-general by date:

Previous
From: "Jose Torres"
Date:
Subject: Need Windows 2008 support and old installer kind
Next
From: Craig Ringer
Date:
Subject: Re: C-Functions using SPI - Missing Magic Block