pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAbout autovacuum
2+ messages / 2 participants
[nested] [flat]
* About autovacuum
@ 2007-09-04 18:39 Jean-David Beyer <jeandavid8@verizon.net>
2007-09-04 19:01 ` Re: About autovacuum Bill Moran <wmoran@collaborativefusion.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jean-David Beyer @ 2007-09-04 18:39 UTC (permalink / raw)
To: pgsql-performance
I have this turned on, and if I look at the log, it runs once a minute,
which is fine.
But what does it do? I.e, it runs VACUUM, but does it also do an analyze?
--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ PGP-Key: 9A2FC99A Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 14:35:01 up 26 days, 17:57, 2 users, load average: 4.31, 4.40, 4.78
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: About autovacuum
2007-09-04 18:39 About autovacuum Jean-David Beyer <jeandavid8@verizon.net>
@ 2007-09-04 19:01 ` Bill Moran <wmoran@collaborativefusion.com>
0 siblings, 0 replies; 2+ messages in thread
From: Bill Moran @ 2007-09-04 19:01 UTC (permalink / raw)
To: Jean-David Beyer <jeandavid8@verizon.net>; +Cc: pgsql-performance
In response to Jean-David Beyer <jeandavid8@verizon.net>:
> I have this turned on, and if I look at the log, it runs once a minute,
> which is fine.
>
> But what does it do? I.e, it runs VACUUM, but does it also do an analyze?
Yes. If you turn up the debugging level, you'll see detailed log
messages about its activities.
There were discussions on other lists about improving autovacuum's log
messages, I'm pretty sure it will log more helpful information in 8.3.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-09-04 19:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-04 18:39 About autovacuum Jean-David Beyer <jeandavid8@verizon.net>
2007-09-04 19:01 ` Bill Moran <wmoran@collaborativefusion.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