Re: a few doubts regarding postgres

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