Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group