Locking in Inheritance partition

Поиск
Список
Период
Сортировка
От Gaurav Anand
Тема Locking in Inheritance partition
Дата
Msg-id CAMZ99nd5AxvTi9ydjv-FJWmaWbo-npoqLciOmyOPhm7BERjEPQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Locking in Inheritance partition  (Thomas Kellerer <shammat@gmx.net>)
Список pgsql-admin
Hi Team,

We have a declarative partition on tables in our database which is PG10. We face issues as the table becomes locked during attach and detach and cannot be used during the event.

We have a master and slave setup and application query points to Slave but whenever we perform attach and detach of partitions on Master the locks propagates to slave and causes Application to spin.

Kindly suggest if  Inheritance partition will help here or any other way I can avoid this lock.

Thanks,
Gaurav
--

Thanks.

Regards,
Gaurav Anand

logo

This communication is confidential and subject to and governed by Saama’s Electronic Communications Disclaimer.

 

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

Предыдущее
От: abbas alizadeh
Дата:
Сообщение: Last login time
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Locking in Inheritance partition