Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE34B8FE@algol.sollentuna.se
обсуждение исходный текст
Ответ на ANALYZE locks pg_listener in EXCLUSIVE for long time?  (Philip Warner <pjw@rhyme.com.au>)
Список pgsql-hackers
> I'm not sure how would one "send to the other backends."
> Maybe write another file on disk, one for each remote
> backend?  Surely this can be done somehow.  I've heard that
> on linux-2.6 they are implementing "POSIX message queues"
> (not sure what those are anyway); maybe we can do that on
> platforms that support it, for performance.

Dunno if this is relevant, but if you want to go with message queues,
there is also SystemV message queues. Since postgresql already uses sysv
semaphores and shared memory, this would perhaps be portable to more
systems that pg supports today (though you'd still need some kind of
abstraction layer, since e.g. win32 does not have it).
(man msgsnd, msgrcv, msgctl, msgget



//Magnus



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?