dropping partitions and concurrent reads

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема dropping partitions and concurrent reads
Дата
Msg-id 1253041511.29243.39.camel@monkey-cat.sm.truviso.com
обсуждение исходный текст
Ответы Re: dropping partitions and concurrent reads  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
S1, S2 are concurrent sessions:

S1: create table test_par (v int);
S1: create table test_ch1 (check (v > 0 and v <= 2)) inherits (test_par);
S1: create table test_ch2 (check (v > 2 and v <= 4)) inherits (test_par);
S1: begin;
S1: drop table test_ch1 cascade;

S2: select * from test_par where v = 3;

S1: commit;

in S2 I get:
 ERROR:  could not open relation with OID 66962

This can happen without partitioning by dropping the table you're
reading. That won't ever be better than an ERROR, because obviously you
can't answer the query without the table.

However it seems to be worse in the case of inheritance/partitioning
because you are dropping a table that you don't need to answer the
select query. Also, it seems like a common use-case for partitioning.

Acquiring an ACCESS EXCLUSIVE lock on the parent is a workaround. Should
we do that when dropping a child table? Or can plan invalidation correct
this?

Regards,Jeff Davis



В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: WIP: generalized index constraints
Следующее
От: Robert Haas
Дата:
Сообщение: Re: WIP: generalized index constraints