pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
8.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