Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Database size Vs performance degradation

  • From: Richard Huxton <dev(at)archonet(dot)com>
  • To: Dave North <DNorth(at)signiant(dot)com>
  • Cc: pgsql-performance(at)postgresql(dot)org
  • Subject: Re: Database size Vs performance degradation
  • Date: Wed, 30 Jul 2008 18:18:25 +0100
  • Message-id: <4890A261.8040802@archonet.com> <text/plain>
Dave North wrote:

-----Original Message-----
From: Richard Huxton [mailto:dev(at)archonet(dot)com] 



Well, that's pretty much the definition of bloat. Are you sure you're
vacuuming enough?

DN: Well, the auto-vac is kicking off pretty darn frequently...around
once every 2 minutes.  However, you just made me think of the obvious -
is it actually doing anything?!  The app is pretty darn write intensive
so I wonder if it's actually able to vacuum the tables?
If you've got a big batch delete, it can't hurt to manually vacuum that table immediately afterwards. 

--
  Richard Huxton
  Archonet Ltd
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group