Re: locks in CREATE TRIGGER, ADD FK

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
Cc: Neil Conway <neilc(at)samurai(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: locks in CREATE TRIGGER, ADD FK
Date: 2005-03-23 02:42:01
Message-ID: 4240D779.3070103@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 building the new, then grab
an exclusive lock to swap the two.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-03-23 02:42:58 Re: odd problem !
Previous Message Bruce Momjian 2005-03-23 02:41:48 Re: psql and pg_dump using obselete copy commands