Re: locks in CREATE TRIGGER, ADD FK

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: locks in CREATE TRIGGER, ADD FK
Дата
Msg-id 4240D779.3070103@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: locks in CREATE TRIGGER, ADD FK  (Russell Smith <mr-russ@pws.com.au>)
Ответы Re: locks in CREATE TRIGGER, ADD FK  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: locks in CREATE TRIGGER, ADD FK  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
>>If you want to be my friend forever, then fix CLUSTER so that it uses 
>>sharerowexclusive as well :D
> 
> I don't think it's as easy as that, because you have to move tuples
> around in the cluster operation.  Same sort of issue as vacuum full I would suggest.

Cluster doesn't move rows...

I didn't say it was easy.  It would involve changing how cluster works.  It would keep the old table around while
buildingthe new, then grab 
 
an exclusive lock to swap the two.

Chris


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

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: locks in CREATE TRIGGER, ADD FK
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: psql and pg_dump using obselete copy commands