Re: What needs to be done for real Partitioning?

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: What needs to be done for real Partitioning?
Дата
Msg-id 20050320001623.GA16805@uio.no
обсуждение исходный текст
Ответ на Re: What needs to be done for real Partitioning?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Sat, Mar 19, 2005 at 07:03:19PM -0500, Tom Lane wrote:
> Possibly, but I'm concerned about locking and deadlock issues.  The
> reason that this is iffy is you would start the operation with only
> an INSERT-grade lock, and then discover that you needed to add a
> partition, which is surely something that needs an exclusive-grade
> lock (consider two sessions trying to add the same partition at the
> same time).  So I don't see how to do it without lock upgrading,
> and lock upgrading is always a recipe for deadlocks.

What about letting something periodical (say, vacuum) do this?

/* Steinar */
--
Homepage: http://www.sesse.net/

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What needs to be done for real Partitioning?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: What needs to be done for real Partitioning?