Re: autovacuum ignore tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum ignore tables
Дата
Msg-id 3831.1159565887@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: autovacuum ignore tables  ("Sriram Dandapani" <sdandapani@counterpane.com>)
Список pgsql-admin
"Sriram Dandapani" <sdandapani@counterpane.com> writes:
> Real question is: Why do the INSERTS go into wait state as soon as the
> lock table statement is issued on the parent?

If you were just inserting directly into other child tables, a lock on
either the parent or the target child table shouldn't affect them.
I wonder if you are using conditional rules to redirect the inserts,
and the rules include a reference to the target table?  If that's the
case, you really need to drop the relevant rule before you remove the
child table, anyway.

            regards, tom lane

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: How can I restore from WAL log? [PG 7.3]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [JDBC] number of transactions doubling