| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Terry Lee Tucker <terry(at)esc1(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: a few doubts regarding postgres |
| Date: | 2005-02-11 15:04:50 |
| Message-ID: | 420CC992.1000107@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2005-02-11 15:32:13 | Re: ADO adCmdStoredProc PlPgSql-SP Parameters |
| Previous Message | James Thompson | 2005-02-11 14:58:21 | Re: Python Driver |