Re: Question about DROP TABLE - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Question about DROP TABLE
Date
Msg-id CAFj8pRDQN6pZqWR-2L7e8SEagao0vhCsLpDS4uHyGfhVfT1Y5w@mail.gmail.com
Whole thread Raw
In response to Re: Question about DROP TABLE  (Marko Tiikkaja <marko@joh.to>)
List pgsql-hackers


2016-01-12 12:22 GMT+01:00 Marko Tiikkaja <marko@joh.to>:
On 12/01/16 12:17, Pavel Stehule wrote:
2016-01-12 12:14 GMT+01:00 Michal Novotny <michal.novotny@trustport.com>:

Hi Pavel,
thanks for the information. I've been doing more investigation of this
issue and there's autovacuum running on the table however it's
automatically starting even if there is "autovacuum = off" in the
postgresql.conf configuration file.


Real autovacuum is automatically cancelled. It looks like VACUUM started by
cron, maybe?

Not if it's to prevent wraparound, which isn't unlikely if autovacuum=off.

I didn't know it.

Thank you

Pavel
 


.m

pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: Question about DROP TABLE
Next
From: Michal Novotny
Date:
Subject: Re: Question about DROP TABLE