Re: autovacuum

On Sep 20, 2007, at 3:47 PM, Joshua D. Drake wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Bill Moran wrote:
>> In response to Robert Fitzpatrick <lists@webtent.net>:
>>
>>> On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
>>>> In response to Robert Fitzpatrick <lists@webtent.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?

You ARE have disks ;)


Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com