Re: any experience with multithreaded pg apps? - Mailing list pgsql-general

From Jeff
Subject Re: any experience with multithreaded pg apps?
Date
Msg-id EDD788FC-A056-11D8-A5C9-000D9366F0C4@torgo.978.org
Whole thread Raw
In response to any experience with multithreaded pg apps?  (Mark Harrison <mh@pixar.com>)
List 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 by date:

Previous
From: Jeff Boes
Date:
Subject: Re: Interpreting vacuum verbosity
Next
From: Tom Lane
Date:
Subject: Re: Interpreting vacuum verbosity