Re: Improve the concurency of vacuum full table and select statement on the same relation

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Jinyu <call_jinyu(at)126(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improve the concurency of vacuum full table and select statement on the same relation
Date: 2015-10-12 15:46:12
Message-ID: 561BD5C4.9080903@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/11/15 6:55 AM, Jinyu wrote:
> Are there other solutions to improve the concurency of vacuum
> full/cluster and select statement on the same relation?

ISTM that if we were going to put effort into this it makes more sense
to pull pg_repack into core. BTW, it's approach to this is to summarily
kill anything that attempts DDL on a table being repacked.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message kolo hhmow 2015-10-12 16:01:56 pam auth - add rhost item
Previous Message Robert Haas 2015-10-12 15:46:08 Re: Parallel Seq Scan