From: Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
To: pgsql-performance@postgresql.org
Subject: Vacuum performance question
Date: Thu, 14 Aug 2003 12:55:32 -0500
Message-ID: <200308141255.36225.jeremy.guthrie@berbee.com> (raw)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
My database is approximately 8gb in size. My application is 24/7. I'm
constantly cycling through data. I analyze every 15 minutes but I'm noticing
that during a vacuum the database becomes extremely sluggish.
In some cases the operation of my software goes from 1-3 second runtime to
300+ seconds during a vacuum.
Should I expect this with a vacuum? I've done reading online where people say
they see only a 10% decrease in speed. Is this supposed to be the norm?
I've allocated 196MB of RAM to vacuums.
The system is a dual P4-2.4ghz w/ 1.5 gig of RAM w/ 36 gig of RAID mirrored
disk.
I'm runing 7.3.2 and I am upgrading to 7.3.3 next week.
Please advise.
- --
Jeremy M. Guthrie
Systems Engineer
Berbee
5520 Research Park Dr.
Madison, WI 53711
Phone: 608-298-1061
Berbee...Decade 1. 1993-2003
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/O80UqtjaBHGZBeURAqmLAJ9kxh0DyaZm3pAP77XGlDTq5JcsowCfeqpC
36SjIo5XW44bEkmHnbwXXBQ=
=oozQ
-----END PGP SIGNATURE-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: jeremy.guthrie@berbee.com
Subject: Re: Vacuum performance question
In-Reply-To: <200308141255.36225.jeremy.guthrie@berbee.com>
References: <200308141255.36225.jeremy.guthrie@berbee.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox