pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed8.1.3 - autovacuum question
8+ messages / 5 participants
[nested] [flat]
* 8.1.3 - autovacuum question
@ 2006-06-26 20:38 Chris Hoover <revoohc@gmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: Chris Hoover @ 2006-06-26 20:38 UTC (permalink / raw)
To: pgsql-admin
I turned on autovacuum on one of my database servers over the weekend. I
have been looking at the logs trying to see what it is doing. However, all
I see are lines like this:
,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
database "postgres"
Is there a way to tell if autovacuum is actually doing any work? As far as
I can see, it is running, but has not done any work. Thanks for any help on
tracking what autovacuum is doing.
Chris
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: 8.1.3 - autovacuum question
@ 2006-06-26 20:59 Alvaro Herrera <alvherre@commandprompt.com>
parent: Chris Hoover <revoohc@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Alvaro Herrera @ 2006-06-26 20:59 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin
Chris Hoover wrote:
> I turned on autovacuum on one of my database servers over the weekend. I
> have been looking at the logs trying to see what it is doing. However, all
> I see are lines like this:
> ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> database "postgres"
>
> Is there a way to tell if autovacuum is actually doing any work?
Yeah, autovacuum is pretty stupid in its logging. You can put
log_min_messages (or min_log_messages, I always forget which one it is)
DEBUG2 to get more detailed messages. You'll get a lot other stuff as
well :-(
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: 8.1.3 - autovacuum question
@ 2006-06-26 21:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Chris Hoover <revoohc@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Tom Lane @ 2006-06-26 21:03 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin
"Chris Hoover" <revoohc@gmail.com> writes:
> I turned on autovacuum on one of my database servers over the weekend. I
> have been looking at the logs trying to see what it is doing. However, all
> I see are lines like this:
> ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> database "postgres"
> Is there a way to tell if autovacuum is actually doing any work? As far as
> I can see, it is running, but has not done any work.
I think that's all you'll see at the default logging level. There are
per-table messages at DEBUG2 level ... which will enable a whole lot of
other chatter as well :-(
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: 8.1.3 - autovacuum question
@ 2006-06-27 16:49 Chris Hoover <revoohc@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Chris Hoover @ 2006-06-27 16:49 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Are there any plans to fix this so we can see atleast the table activity (
i.e. vacuuming table x) any time soon?
Thanks,
Chris
On 6/26/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Chris Hoover" <revoohc@gmail.com> writes:
> > I turned on autovacuum on one of my database servers over the
> weekend. I
> > have been looking at the logs trying to see what it is doing. However,
> all
> > I see are lines like this:
> > ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> > database "postgres"
> > Is there a way to tell if autovacuum is actually doing any work? As far
> as
> > I can see, it is running, but has not done any work.
>
> I think that's all you'll see at the default logging level. There are
> per-table messages at DEBUG2 level ... which will enable a whole lot of
> other chatter as well :-(
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: 8.1.3 - autovacuum question
@ 2006-06-28 04:47 Jim C. Nasby <jnasby@pervasive.com>
parent: Chris Hoover <revoohc@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Jim C. Nasby @ 2006-06-28 04:47 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin
Yes, and I belive they're in HEAD now.
On Tue, Jun 27, 2006 at 12:49:25PM -0400, Chris Hoover wrote:
> Are there any plans to fix this so we can see atleast the table activity (
> i.e. vacuuming table x) any time soon?
>
> Thanks,
>
> Chris
>
> On 6/26/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >
> >"Chris Hoover" <revoohc@gmail.com> writes:
> >> I turned on autovacuum on one of my database servers over the
> >weekend. I
> >> have been looking at the logs trying to see what it is doing. However,
> >all
> >> I see are lines like this:
> >> ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> >> database "postgres"
> >> Is there a way to tell if autovacuum is actually doing any work? As far
> >as
> >> I can see, it is running, but has not done any work.
> >
> >I think that's all you'll see at the default logging level. There are
> >per-table messages at DEBUG2 level ... which will enable a whole lot of
> >other chatter as well :-(
> >
> > regards, tom lane
> >
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: 8.1.3 - autovacuum question
@ 2006-06-28 14:24 Chris Hoover <revoohc@gmail.com>
parent: Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 8+ messages in thread
From: Chris Hoover @ 2006-06-28 14:24 UTC (permalink / raw)
To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin
Any chance of a backport to 8.1? It sure would be a big help to be able to
see what autvacuum is doing and to make sure that life is happy that way.
Thanks,
Chris
On 6/28/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
>
> Yes, and I belive they're in HEAD now.
>
> On Tue, Jun 27, 2006 at 12:49:25PM -0400, Chris Hoover wrote:
> > Are there any plans to fix this so we can see atleast the table activity
> (
> > i.e. vacuuming table x) any time soon?
> >
> > Thanks,
> >
> > Chris
> >
> > On 6/26/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > >
> > >"Chris Hoover" <revoohc@gmail.com> writes:
> > >> I turned on autovacuum on one of my database servers over the
> > >weekend. I
> > >> have been looking at the logs trying to see what it is
> doing. However,
> > >all
> > >> I see are lines like this:
> > >> ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> > >> database "postgres"
> > >> Is there a way to tell if autovacuum is actually doing any work? As
> far
> > >as
> > >> I can see, it is running, but has not done any work.
> > >
> > >I think that's all you'll see at the default logging level. There are
> > >per-table messages at DEBUG2 level ... which will enable a whole lot of
> > >other chatter as well :-(
> > >
> > > regards, tom lane
> > >
>
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: 8.1.3 - autovacuum question
@ 2006-06-28 14:28 Bruce Momjian <bruce@momjian.us>
parent: Chris Hoover <revoohc@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Bruce Momjian @ 2006-06-28 14:28 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: Jim C. Nasby <jnasby@pervasive.com>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin
Chris Hoover wrote:
> Any chance of a backport to 8.1? It sure would be a big help to be able to
> see what autvacuum is doing and to make sure that life is happy that way.
No, it is a feature addition.
---------------------------------------------------------------------------
>
> Thanks,
>
> Chris
>
> On 6/28/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> >
> > Yes, and I belive they're in HEAD now.
> >
> > On Tue, Jun 27, 2006 at 12:49:25PM -0400, Chris Hoover wrote:
> > > Are there any plans to fix this so we can see atleast the table activity
> > (
> > > i.e. vacuuming table x) any time soon?
> > >
> > > Thanks,
> > >
> > > Chris
> > >
> > > On 6/26/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > > >
> > > >"Chris Hoover" <revoohc@gmail.com> writes:
> > > >> I turned on autovacuum on one of my database servers over the
> > > >weekend. I
> > > >> have been looking at the logs trying to see what it is
> > doing. However,
> > > >all
> > > >> I see are lines like this:
> > > >> ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> > > >> database "postgres"
> > > >> Is there a way to tell if autovacuum is actually doing any work? As
> > far
> > > >as
> > > >> I can see, it is running, but has not done any work.
> > > >
> > > >I think that's all you'll see at the default logging level. There are
> > > >per-table messages at DEBUG2 level ... which will enable a whole lot of
> > > >other chatter as well :-(
> > > >
> > > > regards, tom lane
> > > >
> >
> > --
> > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
> > Pervasive Software http://pervasive.com work: 512-231-6117
> > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
> >
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: 8.1.3 - autovacuum question
@ 2006-06-28 15:21 Jim C. Nasby <jnasby@pervasive.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 8+ messages in thread
From: Jim C. Nasby @ 2006-06-28 15:21 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Chris Hoover <revoohc@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin
On Wed, Jun 28, 2006 at 10:28:31AM -0400, Bruce Momjian wrote:
> Chris Hoover wrote:
> > Any chance of a backport to 8.1? It sure would be a big help to be able to
> > see what autvacuum is doing and to make sure that life is happy that way.
>
> No, it is a feature addition.
You could probably dig up the appropriate patch and apply it to 8.1
yourself, though. It should be pretty non-invasive.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2006-06-28 15:21 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-26 20:38 8.1.3 - autovacuum question Chris Hoover <revoohc@gmail.com>
2006-06-26 20:59 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-06-26 21:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-06-27 16:49 ` Chris Hoover <revoohc@gmail.com>
2006-06-28 04:47 ` Jim C. Nasby <jnasby@pervasive.com>
2006-06-28 14:24 ` Chris Hoover <revoohc@gmail.com>
2006-06-28 14:28 ` Bruce Momjian <bruce@momjian.us>
2006-06-28 15:21 ` Jim C. Nasby <jnasby@pervasive.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