pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
When vaccuum full should be performed with postgresql-8.1 and autovaccuum?
2+ messages / 2 participants
[nested] [flat]

* When vaccuum full should be performed with postgresql-8.1 and autovaccuum?
@ 2006-09-18 10:18  Arnau <arnaulist@andromeiberica.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Arnau @ 2006-09-18 10:18 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

   I'm migrating our DDBB from postgresql 7.4 to postgresql 8.1. In 
postgreql 7.4 we don't have autovaccum running. So, every night before 
doing the daily backup we do a "vaccuumdb -f -z" for each DB. My doubt 
is, the autovaccuum  with the version 8.1 is started by default and I 
don't know how often I should perform the "vaccuumdb -f -z" or now it's 
not necessary to do it at all.

Thank you very much
-- 
Arnau



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: When vaccuum full should be performed with postgresql-8.1
@ 2006-09-19 04:08  Matthew T. O'Connor <matthew@zeut.net>
  parent: Arnau <arnaulist@andromeiberica.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Matthew T. O'Connor @ 2006-09-19 04:08 UTC (permalink / raw)
  To: arnaulist@andromeiberica.com; +Cc: pgsql-admin

Arnau wrote:
> I'm migrating our DDBB from postgresql 7.4 to postgresql 8.1. In 
> postgreql 7.4 we don't have autovaccum running. So, every night before 
> doing the daily backup we do a "vaccuumdb -f -z" for each DB. My doubt 
> is, the autovaccuum  with the version 8.1 is started by default and I 
> don't know how often I should perform the "vaccuumdb -f -z" or now 
> it's not necessary to do it at all. 
First off, you should never really need vacuumdb -f, in fact autovacuum 
doesn't do full vacuums, rather it only does the standard vacuum.

In theory autovacuum should perform all the vacuuming that is needed, 
however, in practice this isn't always the case.  First the most people 
find the default thresholds for autovacuum in 8.1 are too conservative 
and second it can be a bit hard to monitor what autovacuum is doing.  
Both of these issues are improved in 8.2.  In summary, try it and see.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-09-19 04:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-18 10:18 When vaccuum full should be performed with postgresql-8.1 and autovaccuum? Arnau <arnaulist@andromeiberica.com>
2006-09-19 04:08 ` Re: When vaccuum full should be performed with postgresql-8.1 Matthew T. O'Connor <matthew@zeut.net>

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