pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
 about the performance of autovacuum and vacuumdb? 選項
4+ messages / 3 participants
[nested] [flat]

*  about the performance of autovacuum and vacuumdb? 選項
@ 2007-12-20 06:50 ivan.hou <ivan.hou@msa.hinet.net>
  0 siblings, 0 replies; 4+ messages in thread

From: ivan.hou @ 2007-12-20 06:50 UTC (permalink / raw)
  To: pgsql-admin


i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3) 

1. enable autovacuum without using vacuumdb -f mydb in crontab. 
2. using crontab to vacuumdb in every 10 min (autovacuum disable) 


the method 2 got more free space than method 1. 


the disk size of database still  increased in method 1. 
so, what's the advantage of autovacuum? 



-- 
View this message in context: http://www.nabble.com/about-the-performance-of-autovacuum-and-vacuumdb--%E9%81%B8%E9%A0%85-tp1443169...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




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

* about the performance of autovacuum and vacuumdb?
@ 2007-12-20 06:50 ivan.hou <ivan.hou@msa.hinet.net>
  2007-12-20 18:31 ` Re: about the performance of autovacuum and vacuumdb? Alvaro Herrera <alvherre@commandprompt.com>
  2007-12-20 22:13 ` Re: about the performance of autovacuum and vacuumdb? Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 2 replies; 4+ messages in thread

From: ivan.hou @ 2007-12-20 06:50 UTC (permalink / raw)
  To: pgsql-admin


i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3) 

1. enable autovacuum without using vacuumdb -f mydb in crontab. 
2. using crontab to vacuumdb in every 10 min (autovacuum disable) 


the method 2 got more free space than method 1. 


the disk size of database still  increased in method 1. 
so, what's the advantage of autovacuum?

-- 
View this message in context: http://www.nabble.com/about-the-performance-of-autovacuum-and-vacuumdb--tp14431704p14431704.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




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

* Re: about the performance of autovacuum and vacuumdb?
  2007-12-20 06:50 about the performance of autovacuum and vacuumdb? ivan.hou <ivan.hou@msa.hinet.net>
@ 2007-12-20 18:31 ` Alvaro Herrera <alvherre@commandprompt.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Alvaro Herrera @ 2007-12-20 18:31 UTC (permalink / raw)
  To: ivan.hou <ivan.hou@msa.hinet.net>; +Cc: pgsql-admin

ivan.hou wrote:

> so, what's the advantage of autovacuum?

The fact that it acts on demand.  If it's not taking action soon enough,
you need to adjust the config parameters.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



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

* Re: about the performance of autovacuum and vacuumdb?
  2007-12-20 06:50 about the performance of autovacuum and vacuumdb? ivan.hou <ivan.hou@msa.hinet.net>
@ 2007-12-20 22:13 ` Scott Marlowe <scott.marlowe@gmail.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Scott Marlowe @ 2007-12-20 22:13 UTC (permalink / raw)
  To: ivan.hou <ivan.hou@msa.hinet.net>; +Cc: pgsql-admin

On Dec 20, 2007 12:50 AM, ivan.hou <ivan.hou@msa.hinet.net> wrote:
>
> i try to compare two methods of garbage-collect.(Postgresql Ver:8.1.3)
>
> 1. enable autovacuum without using vacuumdb -f mydb in crontab.
> 2. using crontab to vacuumdb in every 10 min (autovacuum disable)
>
> the method 2 got more free space than method 1.
>
> the disk size of database still  increased in method 1.
> so, what's the advantage of autovacuum?

That really depends.  Did the db size increase at first under method
1, then reach a steady state, or did it just keep bloating.  It might
well be that vacuuming every 10 minutes cost you more in terms of
performance than would using autovacuum, and the trade off was
slightly more disk space used.  Or it could be the db was bloating.
If the db was bloating, as Alvaro mentioned, you likely don't have
aggressive enough settings for autovacuum.

Also, update your pg install to the latest 8.1.x version, 8.1.3 has
quite a few nasty bugs in it.



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


end of thread, other threads:[~2007-12-20 22:13 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-12-20 06:50  about the performance of autovacuum and vacuumdb? 選項 ivan.hou <ivan.hou@msa.hinet.net>
2007-12-20 06:50 about the performance of autovacuum and vacuumdb? ivan.hou <ivan.hou@msa.hinet.net>
2007-12-20 18:31 ` Re: about the performance of autovacuum and vacuumdb? Alvaro Herrera <alvherre@commandprompt.com>
2007-12-20 22:13 ` Re: about the performance of autovacuum and vacuumdb? Scott Marlowe <scott.marlowe@gmail.com>

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