From: | "Carlos Oliva" <carlos(at)pbsinet(dot)com> |
---|---|
To: | "'Matthew T(dot) O'Connor'" <matthew(at)zeut(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance of autovacuum and full vacuum of database |
Date: | 2005-11-11 18:09:45 |
Message-ID: | 200511111813.NAA21395@pbsi.pbsinet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Matthew,
Would rebooting the server interfere with the work of pg_autovacuum? I
imagine that pg_autovacuum would loose the information that it gathered
prior to the reboot.
Would not pg_autovacuum need to gather data about the database again before
it can judge if it should analyze/vacuum a table of the database?
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Matthew T. O'Connor
Sent: Thursday, November 10, 2005 3:44 PM
To: Carlos Oliva
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Performance of autovacuum and full vacuum of database
Carlos Oliva wrote:
> Thank you for your response Matthew. Currently I run pg_autovacuum with
the
> following scripts.
> su -l postgres -c "pg_autovacuum -D -U postgres > /dev/null 2>&1"&
>
> Do you suggest that I could change it to something like the following:
> su -l postgres -c "pg_autovacuum -d2 -D -U postgres > /tmp/vacuum.log
2>&1"&
Yes exactly, and if you find that pg_autovacuum is never or not often
enough firing off vacuum comands, then you will need to play with the
threshold settings. The default thresholds for pg_autovacuum are too
conservative for most people, so you may very well have to do this.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2005-11-11 18:14:00 | Re: Where |
Previous Message | Tom Lane | 2005-11-11 17:52:42 | Re: Best way to use indexes for partial match at |