Re: [HACKERS] Question about ALTER TABLE SET TABLESPACE locing

2006-02-02 Thread Kim Bisgaard
Hannu Krosing wrote: Ühel kenal päeval, K, 2006-02-01 kell 18:08, kirjutas Tom Lane: Hannu Krosing <[EMAIL PROTECTED]> writes: Does ALTER TABLE SET TABLESPACE lock the table It had better ... see nearby discussion about relaxing locking for TRUNCATE. Is it some recent

Re: [HACKERS] Question about ALTER TABLE SET TABLESPACE locing

2006-02-02 Thread Hannu Krosing
Ühel kenal päeval, K, 2006-02-01 kell 18:08, kirjutas Tom Lane: > Hannu Krosing <[EMAIL PROTECTED]> writes: > > Does ALTER TABLE SET TABLESPACE lock the table > > It had better ... see nearby discussion about relaxing locking for > TRUNCATE. Is it some recent disussion ? > Exactly the same pro

Re: [HACKERS] Question about ALTER TABLE SET TABLESPACE locing behaviour

2006-02-01 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes: > Does ALTER TABLE SET TABLESPACE lock the table It had better ... see nearby discussion about relaxing locking for TRUNCATE. Exactly the same problem that at commit we'd be cutting the ground out from under any concurrent query.

[HACKERS] Question about ALTER TABLE SET TABLESPACE locing behaviour

2006-02-01 Thread Hannu Krosing
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 ---(end of broadcast)--- TIP 9: In ve