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@xxxxxxxxxxx>:
On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
In response to Robert Fitzpatrick <lists@xxxxxxxxxxx>:
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@xxxxxxxxxx
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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
