Re: Question about DROP TABLE

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Michal Novotny <michal(dot)novotny(at)trustport(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Question about DROP TABLE
Date: 2016-01-12 11:22:17
Message-ID: 5694E1E9.7040308@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/01/16 12:17, Pavel Stehule wrote:
> 2016-01-12 12:14 GMT+01:00 Michal Novotny <michal(dot)novotny(at)trustport(dot)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.

.m

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2016-01-12 11:25:03 Re: Question about DROP TABLE
Previous Message Andres Freund 2016-01-12 11:20:32 Re: Question about DROP TABLE