Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve the concurency of vacuum full table and select statement on the same relation - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Improve the concurency of vacuum full table and select statement on the same relation
Date
Msg-id 561BD5C4.9080903@BlueTreble.com
Whole thread Raw
In response to Re: Improve the concurency of vacuum full table and select statement on the same relation  (Jinyu <call_jinyu@126.com>)
Responses Re: Improve the concurency of vacuum full table and select statement on the same relation  (Jinyu <call_jinyu@126.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Parallel Seq Scan
Next
From: kolo hhmow
Date:
Subject: pam auth - add rhost item