Re: a few doubts regarding postgres - Mailing list pgsql-general

From Richard Huxton
Subject Re: a few doubts regarding postgres
Date
Msg-id 420CC992.1000107@archonet.com
Whole thread Raw
In response to Re: a few doubts regarding postgres  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
Terry Lee Tucker wrote:
> On Friday 11 February 2005 07:47 am, Shridhar Daithankar saith:
>
>>No. PostgreSQL backend process is single threaded. However each connection
>>gets a separate backend process. Hence on SMP machines, all available CPUs
>>can potentially be used for multiple connections.
>>
>>Regards,
>> Shridhar
>
>
> So then, can I count on the be_pid attribute returned from PQnotifies to be a
> unique value associated only with a given user? I think the answer is yes,
> but just making sure.

Yes (provided you're not running connection pooling).

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: James Thompson
Date:
Subject: Re: Python Driver
Next
From: "Jeff Eckermann"
Date:
Subject: Re: ADO adCmdStoredProc PlPgSql-SP Parameters