Question about ALTER TABLE SET TABLESPACE locing behaviour

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

Peripheral Links

Text Size: Normal / Large
Donate
Contact

The world's most advanced open source database.

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

Re: Question about ALTER TABLE SET TABLESPACE locing behaviour at 2006-02-01 23:08:49 from Tom Lane

pgsql-hackers by date

Next: From: Tom Lane Date: 2006-02-01 23:08:49

Subject: Re: Question about ALTER TABLE SET TABLESPACE locing behaviour

Previous: From: Jim C. Nasby Date: 2006-02-01 21:21:16

Subject: Re: autovacuum

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

Search

Peripheral Links

Question about ALTER TABLE SET TABLESPACE locing behaviour

Responses

pgsql-hackers by date