Re: pgsql: When VACUUM or ANALYZE skips a concurrently dropped table, log i

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: When VACUUM or ANALYZE skips a concurrently dropped table, log i
Date: 2017-12-07 16:17:55
Message-ID: CA+TgmobhT8XcHfjK_K0QxtjXxdNqETinbu7t3qkvgzpz6fCaeQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Wed, Dec 6, 2017 at 9:42 PM, Bossart, Nathan <bossartn(at)amazon(dot)com> wrote:
> On 12/6/17, 8:25 PM, "Robert Haas" <robertmhaas(at)gmail(dot)com> wrote:
>> Please give me a little time to see if I can speed up this test enough
>> to fix this problem. If that doesn't work out, then we can rip this
>> out.
>
> Just in case it got missed earlier, here’s a patch that speeds it
> up enough to pass with CLOBBER_CACHE_ALWAYS enabled. Instead of
> doing database-wide operations, it just uses a partitioned table.

Yeah, that looks like a reasonable approach to try. Committed, thanks.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2017-12-07 18:45:29 Re: pgsql: Support Parallel Append plan nodes.
Previous Message Robert Haas 2017-12-07 16:17:22 pgsql: Speed up isolation test for concurrent VACUUM/ANALYZE behavior.

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2017-12-07 16:28:23 Re: Speeding up pg_upgrade
Previous Message Stephen Frost 2017-12-07 16:04:13 Re: Speeding up pg_upgrade