pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVacuum performance question
3+ messages / 3 participants
[nested] [flat]
* Vacuum performance question
@ 2003-08-14 17:55 Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
2003-08-14 18:04 ` Re: Vacuum performance question Rod Taylor <rbt@rbt.ca>
2003-08-14 19:28 ` Re: Vacuum performance question Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: Jeremy M. Guthrie @ 2003-08-14 17:55 UTC (permalink / raw)
To: pgsql-performance
-----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-----
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Vacuum performance question
2003-08-14 17:55 Vacuum performance question Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
@ 2003-08-14 18:04 ` Rod Taylor <rbt@rbt.ca>
1 sibling, 0 replies; 3+ messages in thread
From: Rod Taylor @ 2003-08-14 18:04 UTC (permalink / raw)
To: jeremy.guthrie@berbee.com; +Cc: pgsql-performance
> I've allocated 196MB of RAM to vacuums.
I would be willing to bet that you have kicked the system into swap
because of this. Hence the large decrease in speed.
Try sliding back to 32MB for vacuum. A ton more ram doesn't really help
it all that much.
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Vacuum performance question
2003-08-14 17:55 Vacuum performance question Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
@ 2003-08-14 19:28 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2003-08-14 19:28 UTC (permalink / raw)
To: jeremy.guthrie@berbee.com; +Cc: pgsql-performance
"Jeremy M. Guthrie" <jeremy.guthrie@berbee.com> writes:
> In some cases the operation of my software goes from 1-3 second runtime to
> 300+ seconds during a vacuum.
That seems like a lot. I concur with the nearby recommendation to
reduce vacuum_mem, but I think there may be another problem. You should
watch top, iostat, vmstat during a vacuum to try to see what resource is
getting saturated.
> I'm runing 7.3.2 and I am upgrading to 7.3.3 next week.
7.3.4, please. 7.3.3 has at least one nasty bug.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-08-14 19:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-14 17:55 Vacuum performance question Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
2003-08-14 18:04 ` Rod Taylor <rbt@rbt.ca>
2003-08-14 19:28 ` Tom Lane <tgl@sss.pgh.pa.us>
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