Re: any experience with multithreaded pg apps?

Поиск
Список
Период
Сортировка
От Jeff
Тема Re: any experience with multithreaded pg apps?
Дата
Msg-id EDD788FC-A056-11D8-A5C9-000D9366F0C4@torgo.978.org
обсуждение исходный текст
Ответ на any experience with multithreaded pg apps?  (Mark Harrison <mh@pixar.com>)
Список pgsql-general
On May 7, 2004, at 12:43 PM, Mark Harrison wrote:

> I'm looking for feedback from anybody who has used pg in a
> multi-threaded program, particularly one in which several
> threads each open a database connection.
>
> It's documented to work in that scenario, but I'm interested
> in anybody who can share some real-world with that.
>

Works great over here.
Our app sits around doing 50-150 requests/sec constantly and spends
most of its time sitting there with a blank look on its face.

Just make sure you take the normal precautions you need to take with
threaded apps (no strtok, etc. )

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


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

Предыдущее
От: Jeff Boes
Дата:
Сообщение: Re: Interpreting vacuum verbosity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Interpreting vacuum verbosity