Re: How to disable the autovacuum ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Esteban Zimanyi <ezimanyi(at)ulb(dot)ac(dot)be>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: How to disable the autovacuum ?
Date: 2021-05-31 13:49:42
Message-ID: 2567531.1622468982@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Esteban Zimanyi <ezimanyi(at)ulb(dot)ac(dot)be> writes:
> Any idea how to disable the autovacuum during the regression and coverage
> tests for the MobilityDB extension ?

TBH, this seems like a pretty bad idea. If your extension doesn't
behave stably with autovacuum it's not going to be much use in the
real world.

In the core tests, we sometimes disable autovac for individual
tables using a per-table storage option, but that's a last resort.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2021-05-31 14:10:19 Re: CREATE COLLATION - check for duplicate options and error out if found one
Previous Message Tom Lane 2021-05-31 13:44:14 Re: why is the permission granted in a non-recursive way and what are the benefits