pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedauto_vacuum
25+ messages / 9 participants
[nested] [flat]
* auto_vacuum
@ 2005-01-05 00:03 Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
2005-01-05 01:01 ` Re: auto_vacuum Matthew T. O'Connor <matthew@zeut.net>
0 siblings, 1 reply; 25+ messages in thread
From: Theo Galanakis @ 2005-01-05 00:03 UTC (permalink / raw)
To: pgsql-admin
Hi,
We are currently running an older version of postgres on linux
redhat, the auto_vacuum is not part of the contrib package for 7.3.2..
Should I install the latest contrib rpm package? Or should I compile
pg_autovacuum from the source?
Theo
______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: auto_vacuum
2005-01-05 00:03 auto_vacuum Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
@ 2005-01-05 01:01 ` Matthew T. O'Connor <matthew@zeut.net>
0 siblings, 0 replies; 25+ messages in thread
From: Matthew T. O'Connor @ 2005-01-05 01:01 UTC (permalink / raw)
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>; +Cc: pgsql-admin
pg_autovacuum should work against Postgresql 7.3.x. I don't know if
compiling it from source, or using a 7.4 rpm will be easier....
Theo Galanakis wrote:
> Hi,
>
> We are currently running an older version of postgres on linux
> redhat, the auto_vacuum is not part of the contrib package for 7.3.2..
> Should I install the latest contrib rpm package? Or should I compile
> pg_autovacuum from the source?
>
> Theo
>
> ______________________________________________________________________
> This email, including attachments, is intended only for the addressee
> and may be confidential, privileged and subject to copyright. If you
> have received this email in error, please advise the sender and delete
> it. If you are not the intended recipient of this email, you must not
> use, copy or disclose its content to anyone. You must not copy or
> communicate to others content that is confidential or subject to
> copyright, unless you have the consent of the content owner.
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: auto_vacuum
@ 2005-01-05 02:32 Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
0 siblings, 0 replies; 25+ messages in thread
From: Theo Galanakis @ 2005-01-05 02:32 UTC (permalink / raw)
To: 'Matthew T. O'Connor' <matthew@zeut.net>; +Cc: pgsql-admin
Hi Mathew,
I have tried the rpm contrib package and it has depenancies on other
packages. So I tired compiling the source with no luck.
http://developer.postgresql.org/docs/pgsql/contrib/
I guess I will just upgrade the server to a newer version.
Theo
-----Original Message-----
From: Matthew T. O'Connor [mailto:matthew@zeut.net]
Sent: Wednesday, 5 January 2005 12:01 PM
To: Theo Galanakis
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] auto_vacuum
pg_autovacuum should work against Postgresql 7.3.x. I don't know if
compiling it from source, or using a 7.4 rpm will be easier....
Theo Galanakis wrote:
> Hi,
>
> We are currently running an older version of postgres on linux
> redhat, the auto_vacuum is not part of the contrib package for 7.3.2..
> Should I install the latest contrib rpm package? Or should I compile
> pg_autovacuum from the source?
>
> Theo
>
> ______________________________________________________________________
> This email, including attachments, is intended only for the addressee
> and may be confidential, privileged and subject to copyright. If you
> have received this email in error, please advise the sender and delete
> it. If you are not the intended recipient of this email, you must not
> use, copy or disclose its content to anyone. You must not copy or
> communicate to others content that is confidential or subject to
> copyright, unless you have the consent of the content owner.
>
^ permalink raw reply [nested|flat] 25+ messages in thread
* Auto vacuum
@ 2007-04-17 20:05 Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 25+ messages in thread
From: Carol Walter @ 2007-04-17 20:05 UTC (permalink / raw)
To: pgsql-admin
I asked questions about auto vacuum earlier. As I said in my earlier
email, when I select autovacuum the system responds that it's "on."
Some here told me when I asked the questions before that I should see
log entries for it when it "kicks off." In postgresql.conf, it says
that the log_destination is 'stderr." Then it redirects "stderr" to
a file named 'postgresql -%Y-%m-%d_%H%M%S.log' in a directory called
pg_log. I don't see any references to auto-vacuum in the log. What
would the references look like? Is there a parameter I need to set
in order to make in put auto vacuum entries in the log?
client_min_messages is set to "notice." log_min_messages is set to
"info." log_error_verbosity is set to "default."
log_min_error_statement is set to "warning."
log_min_duration_statement is set to 1000
Thanks
Carol
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-17 20:14 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 25+ messages in thread
From: Tom Lane @ 2007-04-17 20:14 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> I don't see any references to auto-vacuum in the log. What
> would the references look like?
Which PG version are you running, exactly?
regards, tom lane
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-04-17 20:25 ` Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 25+ messages in thread
From: Carol Walter @ 2007-04-17 20:25 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
8.2.3 is what is reported when I run psql with the -V option.
Thanks,
Carol
On Apr 17, 2007, at 4:14 PM, Tom Lane wrote:
> Carol Walter <walterc@indiana.edu> writes:
>> I don't see any references to auto-vacuum in the log. What
>> would the references look like?
>
> Which PG version are you running, exactly?
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that
> your
> message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-17 20:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
0 siblings, 1 reply; 25+ messages in thread
From: Tom Lane @ 2007-04-17 20:30 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> 8.2.3 is what is reported when I run psql with the -V option.
In 8.2 you need to increase log_min_messages to see anything about
autovacuum. It reports per-database activity at DEBUG1 and per-table
activity at DEBUG2 level. Unfortunately DEBUG2 will fill your log
with a lot of other chatter as well :-(. There's work going on
right now to improve the reporting of autovac activity for 8.3.
regards, tom lane
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-04-18 01:57 ` Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 25+ messages in thread
From: Robert Treat @ 2007-04-18 01:57 UTC (permalink / raw)
To: pgsql-admin; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Carol Walter <walterc@indiana.edu>
On Tuesday 17 April 2007 16:30, Tom Lane wrote:
> Carol Walter <walterc@indiana.edu> writes:
> > 8.2.3 is what is reported when I run psql with the -V option.
>
> In 8.2 you need to increase log_min_messages to see anything about
> autovacuum. It reports per-database activity at DEBUG1 and per-table
> activity at DEBUG2 level. Unfortunately DEBUG2 will fill your log
> with a lot of other chatter as well :-(. There's work going on
> right now to improve the reporting of autovac activity for 8.3.
>
Till then, take a look at pg_stat_all_tables, which contains information on
last autovacuum and autoanalyze runs for each table.
--
Robert Treat
Database Architect
http://www.omniti.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
@ 2007-04-18 21:29 ` Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 25+ messages in thread
From: Carol Walter @ 2007-04-18 21:29 UTC (permalink / raw)
To: Robert Treat <robert@omniti.com>; +Cc: pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Robert,
I did as you suggested and the values for autovacuum are null,
therefore I'm guessing it isn't running. Since postgres reports that
it is running, what other things might keep in from running?
Carol Walter
On Apr 17, 2007, at 9:57 PM, Robert Treat wrote:
> On Tuesday 17 April 2007 16:30, Tom Lane wrote:
>> Carol Walter <walterc@indiana.edu> writes:
>>> 8.2.3 is what is reported when I run psql with the -V option.
>>
>> In 8.2 you need to increase log_min_messages to see anything about
>> autovacuum. It reports per-database activity at DEBUG1 and per-table
>> activity at DEBUG2 level. Unfortunately DEBUG2 will fill your log
>> with a lot of other chatter as well :-(. There's work going on
>> right now to improve the reporting of autovac activity for 8.3.
>>
>
> Till then, take a look at pg_stat_all_tables, which contains
> information on
> last autovacuum and autoanalyze runs for each table.
>
> --
> Robert Treat
> Database Architect
> http://www.omniti.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-19 14:53 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 25+ messages in thread
From: Alvaro Herrera @ 2007-04-19 14:53 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Robert Treat <robert@omniti.com>; pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Carol Walter wrote:
> Robert,
>
> I did as you suggested and the values for autovacuum are null,
> therefore I'm guessing it isn't running. Since postgres reports that
> it is running, what other things might keep in from running?
Too high thresholds? All tables disabled in pg_autovacuum? naptime set
too high?
I suggest you turn log_min_messages more verbose, to DEBUG2, and see if
there are any entries in there regarding autovacuum. If it's running,
you would see it. You would get a message after autovacuum_naptime
seconds.
How long is autovacuum_naptime anyway?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
@ 2007-04-19 17:54 ` Carol Walter <walterc@indiana.edu>
2007-04-19 19:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 20:59 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
0 siblings, 2 replies; 25+ messages in thread
From: Carol Walter @ 2007-04-19 17:54 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Robert Treat <robert@omniti.com>; pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
I certainly appreciate the help you've given. Here's what the code
in this part of postgresql.conf file says.
autovacuum = on
autovacuum_naptime = 30 # time between autovacuum runs, in secs
autovacuum_vacuum_threshold = 500 # min # of tuple updates before
# vacuum
autovacuum_analyze_threshold = 250 # min # of tuple updates before
# analyze
autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before
# vacuum
autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before
# analyze
autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for
# autovac, -1 means use
# vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
# autovac, -1 means use
# vacuum_cost_limit
Thanks so much,
Carol Walter
On Apr 19, 2007, at 10:53 AM, Alvaro Herrera wrote:
> Carol Walter wrote:
>> Robert,
>>
>> I did as you suggested and the values for autovacuum are null,
>> therefore I'm guessing it isn't running. Since postgres reports that
>> it is running, what other things might keep in from running?
>
> Too high thresholds? All tables disabled in pg_autovacuum?
> naptime set
> too high?
>
> I suggest you turn log_min_messages more verbose, to DEBUG2, and
> see if
> there are any entries in there regarding autovacuum. If it's running,
> you would see it. You would get a message after autovacuum_naptime
> seconds.
>
> How long is autovacuum_naptime anyway?
>
> --
> Alvaro Herrera http://
> www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> ---------------------------(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
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-19 19:25 ` Carol Walter <walterc@indiana.edu>
2007-04-19 19:55 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 1 reply; 25+ messages in thread
From: Carol Walter @ 2007-04-19 19:25 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; Robert Treat <robert@omniti.com>; pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
My pg_catalog.pg_autovacuum table contains no entries.
Carol Walter
>
> On Apr 19, 2007, at 10:53 AM, Alvaro Herrera wrote:
>
>> Carol Walter wrote:
>>> Robert,
>>>
>>> I did as you suggested and the values for autovacuum are null,
>>> therefore I'm guessing it isn't running. Since postgres reports
>>> that
>>> it is running, what other things might keep in from running?
>>
>> Too high thresholds? All tables disabled in pg_autovacuum?
>> naptime set
>> too high?
>>
>> I suggest you turn log_min_messages more verbose, to DEBUG2, and
>> see if
>> there are any entries in there regarding autovacuum. If it's
>> running,
>> you would see it. You would get a message after autovacuum_naptime
>> seconds.
>>
>> How long is autovacuum_naptime anyway?
>>
>> --
>> Alvaro Herrera http://
>> www.CommandPrompt.com/
>> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>>
>> ---------------------------(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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 19:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-19 19:55 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 21:03 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 25+ messages in thread
From: Alvaro Herrera @ 2007-04-19 19:55 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Robert Treat <robert@omniti.com>; pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Carol Walter wrote:
> My pg_catalog.pg_autovacuum table contains no entries.
Good.
Now, are there autovacuum entries in the server log?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 19:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 19:55 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
@ 2007-04-19 21:03 ` Carol Walter <walterc@indiana.edu>
2007-04-19 21:07 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 25+ messages in thread
From: Carol Walter @ 2007-04-19 21:03 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Robert Treat <robert@omniti.com>; pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Are you talking about the log that is configured in postgresql.conf?
it goes to stderr and is redirected to pg_log directory with a time
and date stamp in the filename. It doesn't seem to logging anything
but planner statistics.
Carol
On Apr 19, 2007, at 3:55 PM, Alvaro Herrera wrote:
> Carol Walter wrote:
>> My pg_catalog.pg_autovacuum table contains no entries.
>
> Good.
>
> Now, are there autovacuum entries in the server log?
>
> --
> Alvaro Herrera http://
> www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 19:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 19:55 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 21:03 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-19 21:07 ` Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 25+ messages in thread
From: Alvaro Herrera @ 2007-04-19 21:07 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Robert Treat <robert@omniti.com>; pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Carol Walter wrote:
> Are you talking about the log that is configured in postgresql.conf?
> it goes to stderr and is redirected to pg_log directory with a time
> and date stamp in the filename. It doesn't seem to logging anything
> but planner statistics.
Yes, that one. If it's not logging anything but planner statistics,
then maybe those are the only things configured to be logged, which
would be weird but I think it's possible. Change log_min_messages to
debug2 and try again. A lot more messages should show up, including
some about autovacuum.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-19 20:59 ` Robert Treat <robert@omniti.com>
2007-04-19 21:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
1 sibling, 1 reply; 25+ messages in thread
From: Robert Treat @ 2007-04-19 20:59 UTC (permalink / raw)
To: pgsql-admin; +Cc: Carol Walter <walterc@indiana.edu>; Alvaro Herrera <alvherre@commandprompt.com>; Tom Lane <tgl@sss.pgh.pa.us>
On Thursday 19 April 2007 13:54, Carol Walter wrote:
> I certainly appreciate the help you've given. Here's what the code
> in this part of postgresql.conf file says.
>
> autovacuum = on
>
> autovacuum_naptime = 30 # time between autovacuum runs, in secs
> autovacuum_vacuum_threshold = 500 # min # of tuple updates before
> # vacuum
> autovacuum_analyze_threshold = 250 # min # of tuple updates before
> # analyze
> autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before
> # vacuum
> autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before
> # analyze
> autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for
> # autovac, -1 means use
> # vacuum_cost_delay
> #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
> # autovac, -1 means use
> # vacuum_cost_limit
>
Do you know if you have done a reload of the config files since these were
changed? Try doing a select * from pg_settings where name ~ 'autovacuum' to
see what your db is currently using.
--
Robert Treat
Database Architect
http://www.omniti.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 20:59 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
@ 2007-04-19 21:25 ` Carol Walter <walterc@indiana.edu>
2007-04-19 21:35 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 25+ messages in thread
From: Carol Walter @ 2007-04-19 21:25 UTC (permalink / raw)
To: Robert Treat <robert@omniti.com>; +Cc: pgsql-admin@postgresql.org, Alvaro Herrera <alvherre@commandprompt.com>; Tom Lane <tgl@sss.pgh.pa.us>
I'm not sure if we've done a reload. I'm in an academic environment
and our department is in a state of flux right now. I'm in the
process of trying to get up to speed on postgreSQL as fast as I can.
Here is the result set from that query.
select * from pg_settings where name = 'autovacuum';
name | setting | unit | category |
short_desc |
extra_desc | context | vartype | source | min_val | max_val
------------+---------+------+------------
+-----------------------------------+-
-----------+---------+---------+--------------------+---------+---------
autovacuum | on | | Autovacuum | Starts the autovacuum
subprocess. |
| sighup | bool | configuration file | |
(1 row)
Thank you,
Carol
On Apr 19, 2007, at 4:59 PM, Robert Treat wrote:
> On Thursday 19 April 2007 13:54, Carol Walter wrote:
>> I certainly appreciate the help you've given. Here's what the code
>> in this part of postgresql.conf file says.
>>
>> autovacuum = on
>>
>> autovacuum_naptime = 30 # time between autovacuum runs, in
>> secs
>> autovacuum_vacuum_threshold = 500 # min # of tuple updates
>> before
>> # vacuum
>> autovacuum_analyze_threshold = 250 # min # of tuple updates
>> before
>> # analyze
>> autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before
>> # vacuum
>> autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before
>> # analyze
>> autovacuum_vacuum_cost_delay = -1 # default vacuum cost
>> delay for
>> # autovac, -1 means use
>> # vacuum_cost_delay
>> #autovacuum_vacuum_cost_limit = -1 # default vacuum cost
>> limit for
>> # autovac, -1 means use
>> # vacuum_cost_limit
>>
>
> Do you know if you have done a reload of the config files since
> these were
> changed? Try doing a select * from pg_settings where name ~
> 'autovacuum' to
> see what your db is currently using.
>
> --
> Robert Treat
> Database Architect
> http://www.omniti.com
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 20:59 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-19 21:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
@ 2007-04-19 21:35 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-04-20 17:12 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 25+ messages in thread
From: Alvaro Herrera @ 2007-04-19 21:35 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: Robert Treat <robert@omniti.com>; pgsql-admin
Carol Walter wrote:
> I'm not sure if we've done a reload. I'm in an academic environment
> and our department is in a state of flux right now. I'm in the
> process of trying to get up to speed on postgreSQL as fast as I can.
> Here is the result set from that query.
>
> select * from pg_settings where name = 'autovacuum';
Actually could you please try
select * from pg_settings where name like 'autovacuum%';
so that all the other settings show up as well?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto vacuum
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 20:59 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-19 21:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 21:35 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
@ 2007-04-20 17:12 ` Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 25+ messages in thread
From: Carol Walter @ 2007-04-20 17:12 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Robert Treat <robert@omniti.com>; pgsql-admin
Yes, Here's the results table
name | setting | unit | category |
short_desc | ex
tra_desc | context | vartype | source | min_val |
max_val
---------------------------------+-----------+------+------------
+--------------
------------------------------------------------------------------------
----+---
---------+------------+---------+--------------------+-----------
+------------
autovacuum | on | | Autovacuum |
Starts the au
tovacuum
subprocess. |
| sighup | bool | configuration file | |
autovacuum_analyze_scale_factor | 0.1 | | Autovacuum |
Number of tup
le inserts, updates or deletes prior to analyze as a fraction of
reltuples. |
| sighup | real | configuration file | 0 | 100
autovacuum_analyze_threshold | 250 | | Autovacuum |
Minimum numbe
r of tuple inserts, updates or deletes prior to
analyze. |
| sighup | integer | configuration file | 0 |
2147483647
autovacuum_freeze_max_age | 200000000 | | Autovacuum | Age
at which
to autovacuum a table to prevent transaction ID
wraparound. |
| postmaster | integer | default | 100000000 |
2000000000
autovacuum_naptime | 30 | s | Autovacuum |
Time to sleep
between autovacuum runs, in
seconds. |
| sighup | integer | configuration file | 1 |
2147483647
autovacuum_vacuum_cost_delay | -1 | ms | Autovacuum |
Vacuum cost d
elay in milliseconds, for
autovacuum. |
| sighup | integer | configuration file | -1 | 1000
autovacuum_vacuum_cost_limit | -1 | | Autovacuum |
Vacuum cost a
mount available before napping, for
autovacuum. |
| sighup | integer | default | -1 |
10000
autovacuum_vacuum_scale_factor | 0.2 | | Autovacuum |
Number of tup
le updates or deletes prior to vacuum as a fraction of
reltuples. |
| sighup | real | configuration file | 0 | 100
autovacuum_vacuum_threshold | 500 | | Autovacuum |
Minimum numbe
r of tuple updates or deletes prior to
vacuum. |
| sighup | integer | configuration file | 0 |
2147483647
(9 rows)
Got lots more data with that command. ;-)
Carol Walter
On Apr 19, 2007, at 5:35 PM, Alvaro Herrera wrote:
> Carol Walter wrote:
>> I'm not sure if we've done a reload. I'm in an academic environment
>> and our department is in a state of flux right now. I'm in the
>> process of trying to get up to speed on postgreSQL as fast as I can.
>> Here is the result set from that query.
>>
>> select * from pg_settings where name = 'autovacuum';
>
> Actually could you please try
>
> select * from pg_settings where name like 'autovacuum%';
>
> so that all the other settings show up as well?
>
> --
> Alvaro Herrera http://
> www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
^ permalink raw reply [nested|flat] 25+ messages in thread
* auto vacuum
@ 2010-11-10 18:42 Dinesh Bhandary <dbhandary@iii.com>
0 siblings, 0 replies; 25+ messages in thread
From: Dinesh Bhandary @ 2010-11-10 18:42 UTC (permalink / raw)
To: pgsql-admin
Hi All -
We run both postgres 8.2.3 and 8.4.1 in unix environment. We have auto
vacuum configured and I am trying to find out its effectiveness. Here
are a couple of questions:
1) I'm running a query that compares actual table count with the pg_stat
table count ( pg_stat_user_tables.n_live_tup) to make sure there is not
a huge difference between two. If the difference is small or within the
analyze threshold I know vacuum analyze is running and doing its work. I
am seeing that truncate does not trigger autovacuum analayze like delete
does and pg_stat_user_tables.n_live_tup is not updated ( please correct
me If I am wrong). Does it mean I have to run analyze manually whenever
I truncate a table or system has a way of tracking.
2) In postgres 8.2 pg_stat_user_tables.n_live_tup field is missing. Is
there a way to get table counts as the system sees it in 8.2?
Thanks.
Dinesh
^ permalink raw reply [nested|flat] 25+ messages in thread
* Auto Vacuum
@ 2012-10-18 08:13 teyking2003 <tchongking@hotmail.com>
2012-10-19 17:49 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: teyking2003 @ 2012-10-18 08:13 UTC (permalink / raw)
To: pgsql-admin
Can anyone provide me a sample of auto vacuum and also step by step to
configure it inside my linux ubuntu server?
thanks
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Auto-Vacuum-tp5728770.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto Vacuum
2012-10-18 08:13 Auto Vacuum teyking2003 <tchongking@hotmail.com>
@ 2012-10-19 17:49 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-10-19 18:10 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Scott Marlowe @ 2012-10-19 17:49 UTC (permalink / raw)
To: teyking2003 <tchongking@hotmail.com>; +Cc: pgsql-admin
On Thu, Oct 18, 2012 at 2:13 AM, teyking2003 <tchongking@hotmail.com> wrote:
> Can anyone provide me a sample of auto vacuum and also step by step to
> configure it inside my linux ubuntu server?
Here's the basic instructions on autovacuum for pgsql 8.2. Note that
since it's out of support, if you run into any bugs or problems with
it you're likely to be told to upgrade.
http://www.postgresql.org/docs/8.2/static/runtime-config-autovacuum.html
As long as it's on (first setting on that page) the default values are
fine for most low to medium level usage patterns. If you are doing
enough work that you need to tune autovacuum, then you DEFINITELY need
to upgrade to a more recent version of pgsql than 8.2.
The biggest issue with 8.2 is that autovacuum is not multi-threaded.
One long running vacuum thread can allow multiple tables to get
bloated in a busy server. Also some bugs in vacuum have been fixed
since 8.2 was end of lifed, so you may run into them as well.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto Vacuum
2012-10-18 08:13 Auto Vacuum teyking2003 <tchongking@hotmail.com>
2012-10-19 17:49 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
@ 2012-10-19 18:10 ` Scott Marlowe <scott.marlowe@gmail.com>
2012-10-20 00:16 ` Re: Auto Vacuum teyking2003 <tchongking@hotmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: Scott Marlowe @ 2012-10-19 18:10 UTC (permalink / raw)
To: teyking2003 <tchongking@hotmail.com>; +Cc: pgsql-admin
On Fri, Oct 19, 2012 at 11:49 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Thu, Oct 18, 2012 at 2:13 AM, teyking2003 <tchongking@hotmail.com> wrote:
>> Can anyone provide me a sample of auto vacuum and also step by step to
>> configure it inside my linux ubuntu server?
>
> Here's the basic instructions on autovacuum for pgsql 8.2. Note that
> since it's out of support, if you run into any bugs or problems with
> it you're likely to be told to upgrade.
>
> http://www.postgresql.org/docs/8.2/static/runtime-config-autovacuum.html
>
> As long as it's on (first setting on that page) the default values are
> fine for most low to medium level usage patterns. If you are doing
> enough work that you need to tune autovacuum, then you DEFINITELY need
> to upgrade to a more recent version of pgsql than 8.2.
>
> The biggest issue with 8.2 is that autovacuum is not multi-threaded.
> One long running vacuum thread can allow multiple tables to get
> bloated in a busy server. Also some bugs in vacuum have been fixed
> since 8.2 was end of lifed, so you may run into them as well.
As a followup, you can use this page:
http://wiki.postgresql.org/wiki/Show_database_bloat
and the referenced check_postgresql script:
http://bucardo.org/wiki/Check_postgres
To keep track of how much bloat is in your db. I highly recommend
check_postgresql.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto Vacuum
2012-10-18 08:13 Auto Vacuum teyking2003 <tchongking@hotmail.com>
2012-10-19 17:49 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
2012-10-19 18:10 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
@ 2012-10-20 00:16 ` teyking2003 <tchongking@hotmail.com>
2012-10-25 01:55 ` Re: Auto Vacuum teyking2003 <tchongking@hotmail.com>
0 siblings, 1 reply; 25+ messages in thread
From: teyking2003 @ 2012-10-20 00:16 UTC (permalink / raw)
To: pgsql-admin
i am not sure autovacuum is running in the system or not? any command to
check it out? i have about 1.3GB database in our server. please advice do we
still need this autovacuum or we can keep for our daily manual vacuum?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Auto-Vacuum-tp5728770p5729130.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 25+ messages in thread
* Re: Auto Vacuum
2012-10-18 08:13 Auto Vacuum teyking2003 <tchongking@hotmail.com>
2012-10-19 17:49 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
2012-10-19 18:10 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
2012-10-20 00:16 ` Re: Auto Vacuum teyking2003 <tchongking@hotmail.com>
@ 2012-10-25 01:55 ` teyking2003 <tchongking@hotmail.com>
0 siblings, 0 replies; 25+ messages in thread
From: teyking2003 @ 2012-10-25 01:55 UTC (permalink / raw)
To: pgsql-admin
hi can anyone reply me on my database status base on the vacuum verbose
provided?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Auto-Vacuum-tp5728770p5729574.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 25+ messages in thread
end of thread, other threads:[~2012-10-25 01:55 UTC | newest]
Thread overview: 25+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-05 00:03 auto_vacuum Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
2005-01-05 01:01 ` Matthew T. O'Connor <matthew@zeut.net>
2005-01-05 02:32 Re: auto_vacuum Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
2007-04-17 20:05 Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:14 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-17 20:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-17 20:30 ` Re: Auto vacuum Tom Lane <tgl@sss.pgh.pa.us>
2007-04-18 01:57 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-18 21:29 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 14:53 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 17:54 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 19:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 19:55 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 21:03 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 21:07 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-19 20:59 ` Re: Auto vacuum Robert Treat <robert@omniti.com>
2007-04-19 21:25 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2007-04-19 21:35 ` Re: Auto vacuum Alvaro Herrera <alvherre@commandprompt.com>
2007-04-20 17:12 ` Re: Auto vacuum Carol Walter <walterc@indiana.edu>
2010-11-10 18:42 auto vacuum Dinesh Bhandary <dbhandary@iii.com>
2012-10-18 08:13 Auto Vacuum teyking2003 <tchongking@hotmail.com>
2012-10-19 17:49 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
2012-10-19 18:10 ` Re: Auto Vacuum Scott Marlowe <scott.marlowe@gmail.com>
2012-10-20 00:16 ` Re: Auto Vacuum teyking2003 <tchongking@hotmail.com>
2012-10-25 01:55 ` Re: Auto Vacuum teyking2003 <tchongking@hotmail.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