Re: Anyone working on better transaction locking?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Anyone working on better transaction locking?
Дата
Msg-id 3E998182.F06AF82D@Yahoo.com
обсуждение исходный текст
Ответ на Re: Anyone working on better transaction locking?  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-hackers
Michael Paesold wrote:
> I see there is a whole TODO Chapter devoted to the topic. There is the idea
> of pre-forked and persistent backends. That would be very useful in an
> environment where it's quite hard to use connection pooling. We are
> currently working on a mail system for a free webmail. The mda (mail
> delivery agent) written in C connects to the pg database to do some queries
> everytime a new mail comes in. I didn't find a solution for connection
> pooling yet.

I am still playing with the model of reusing connections in a
transparent fashion with a pool manager that uses SCM_RIGHTS messages
over UNIX domain socketpairs. I will scribble down some concept anytime
soon. This will include some more advantages than pure startup cost
reduction, okay?


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Anyone working on better transaction locking?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Anyone working on better transaction locking?