Question about ALTER TABLE SET TABLESPACE locing behaviour

From: Hannu Krosing <hannu(at)skype(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Question about ALTER TABLE SET TABLESPACE locing behaviour
Date: 2006-02-01 21:44:59
Message-ID: 1138830300.4868.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Does ALTER TABLE SET TABLESPACE lock the table while copying data to new
location ?

If so, then does it lock the whole table, or just the tuples belonging
to currently copied 1G file ?

----------------
Hannu

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-02-01 23:08:49 Re: Question about ALTER TABLE SET TABLESPACE locing behaviour
Previous Message Jim C. Nasby 2006-02-01 21:21:16 Re: autovacuum