From: Benjamin Krajmalnik <kraj@illumen.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
Subject: Re: Autovacuum stopped running
Date: Sat, 1 May 2010 11:15:53 -0600
Message-ID: <F4E6A2751A2823418A21D4A160B6898861435F@fletch.stackdump.local> (raw)
In-Reply-To: <4BDBF3C90200002500031147@gw.wicourts.gov>
References: <F4E6A2751A2823418A21D4A160B6898861435B@fletch.stackdump.local>
<4BDBF3C90200002500031147@gw.wicourts.gov>
TO be truthful, I did not check that.
I arrived at the conclusion because although I have 10 autovacuum
threads, none of the tables had been autoanalyzed or autovacuumed in
hours (and due to the nature of the activity they do so every minute).
If I ever see this behavior now I know what to check for :) Thx.
> -----Original Message-----
> From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
> Sent: Saturday, May 01, 2010 8:27 AM
> To: Benjamin Krajmalnik; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Autovacuum stopped running
>
> "Benjamin Krajmalnik" <kraj@illumen.com> wrote:
> > I had a very strange occurrence 2 days ago where autovacuum
> > appears to have stopped running.
>
> What did you see which led you to that conclusion? Did ps show the
> 'autovacuum launcher process'?
>
> > I did not see any error messages in pg_log. The problem caused a
> > file which is usually around 50Mb but which gets updated
> > extensively to grow to 105GB, which in turn brought the server's
> > performance down to unusable levels.
>
> Were there any long-running transactions showing in
> pg_stat_activity? (That would include transactions showing '<IDLE>
> in transaction'.)
>
> -Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kraj@illumen.com, Kevin.Grittner@wicourts.gov
Subject: Re: Autovacuum stopped running
In-Reply-To: <F4E6A2751A2823418A21D4A160B6898861435F@fletch.stackdump.local>
References: <F4E6A2751A2823418A21D4A160B6898861435B@fletch.stackdump.local> <4BDBF3C90200002500031147@gw.wicourts.gov> <F4E6A2751A2823418A21D4A160B6898861435F@fletch.stackdump.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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