Postgres Pro
Downloads
Home   >   mailing lists

Question about ALTER TABLE SET TABLESPACE locing behaviour - Mailing list pgsql-hackers

From Hannu Krosing
Subject Question about ALTER TABLE SET TABLESPACE locing behaviour
Date
Msg-id 1138830300.4868.2.camel@localhost.localdomain
Whole thread Raw
Responses Re: Question about ALTER TABLE SET TABLESPACE locing behaviour  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: A note about testing EXEC_BACKEND on recent Linuxen
Next
From: Tom Lane
Date:
Subject: Re: Question about ALTER TABLE SET TABLESPACE locing behaviour