| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Ranjeet Dhumal <jeetu(dot)dhumal(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_shdepend vacuum. |
| Date: | 2013-02-08 17:39:58 |
| Message-ID: | CAMkU=1z-QYMPRZf86RXfH7TgQSnxzDcBDD5pZ3TZFevCUFjAgA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Feb 7, 2013 at 3:47 AM, Ranjeet Dhumal <jeetu(dot)dhumal(at)gmail(dot)com> wrote:
> Hi All ,
>
> Am using postgres version 9.0.1 .
You should upgrade to the latest minor release. A lot of things have
been fixed since 9.0.1, including better logging of autovacuum cancels
(in 9.0.9) which will tell you what is causing the cancel.
> In daily postgres log am getting same kind of log for many time , is it
> because of more table creation and deletion is going on and its trying to
> vaccum pg_shdepend ?
> But its getting canceled every time , why is it so ?
How do you know it is canceled every time? Unless you have cranked up
your logging, success will not be logged, only cancels.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-02-08 17:52:33 | Re: DROP OWNED BY fails to drop privileges granted by non-owners (was Re: [GENERAL] Bug, Feature, or what else?) |
| Previous Message | Andreas Kretschmer | 2013-02-08 17:37:45 | Re: Bug, Feature, or what else? |