pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Vacuum performance question
3+ messages / 3 participants
[nested] [flat]

* Vacuum performance question
@ 2003-08-14 17:55  Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
  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 18:04  Rod Taylor <rbt@rbt.ca>
  parent: Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
  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 19:28  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
  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