Re: Autovacuum and pg_largeobject

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Norberto Delle <betodelle(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Autovacuum and pg_largeobject
Date: 2010-07-02 23:30:52
Message-ID: 1278113349-sup-926@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Howard Rogers 2010-07-03 00:44:26 Re: DBI::Oracle problems
Previous Message Jose Torres 2010-07-02 23:25:14 Need Windows 2008 support and old installer kind