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

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Improve the concurency of vacuum full table and select statement on the same relation
Дата
Msg-id 561BD5C4.9080903@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Improve the concurency of vacuum full table and select statement on the same relation  (Jinyu <call_jinyu@126.com>)
Ответы Re: Improve the concurency of vacuum full table and select statement on the same relation  (Jinyu <call_jinyu@126.com>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Parallel Seq Scan
Следующее
От: kolo hhmow
Дата:
Сообщение: pam auth - add rhost item