Re: autovacuum

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bill Moran wrote:
> In response to Robert Fitzpatrick <lists(at)webtent(dot)net>:
>
>> On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
>>> In response to Robert Fitzpatrick <lists(at)webtent(dot)net>:
>>>
>>>> I have a large database used with our mail filter. The pg_dumpall
>>>> results in about 3GB with this being the only database in the system
>>>> besides templates and postgres.
>>>>
>>>> I do a vacuum every night after backup and it takes about an hour, is
>>>> this normal for this size db?
>>> "normal" is relative. If it's taking an hour to vacuum 3G, I would say
>>> that either your hardware is undersized/badly configured, or you're
>>> not vacuuming often enough.
>> It is a dual P4 processor supermicro server with 2GB of RAM, so I will
>> need to go over the configuration then? I didn't think it should take so
>> long...
>
> Why does everyone leave of the IO subsystem? It's almost as if many
> people don't realize that disks exist ...

I have disks?

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG8txpATb/zqfZUUQRAlgRAKCUhKoTaTFjYy5fdRktrCuAfWTdlwCgo1wF
Hrg1Dwk+TYxTbWeQEKW2LYY=
=JDqc
-----END PGP SIGNATURE-----