On Mar 31, 2007, at 5:15 PM, Martijn van Oosterhout wrote:
Firstly, with autovacuum you really don't need to be running VACUUM
FULL anyway. VACUUM FULL is actually quite inefficient, you're better
off having higher FSM settings and leaving it to autovacuum.
Thank you (and Bill Moran) for the r
"Eric B. Ridge" <[EMAIL PROTECTED]> wrote:
>
> Hi! We've got a Postgres 8.1.5 installation with a 60GBish database:
>
> =# select version();
> version
>
> ---
> PostgreSQ
On Sat, Mar 31, 2007 at 03:18:35PM -0400, Eric B. Ridge wrote:
> Anyways, we run a VACUUM FULL ANALYZE VERBOSE every night, and it's
> now taking 3+ hours to complete. We also have autovacuum turned on
> with default settings. This 3+ hour vacuum time is cutting into our
> production hours.
Hi! We've got a Postgres 8.1.5 installation with a 60GBish database:
=# select version();
version
---
PostgreSQL 8.1.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4