Re: libpq usage in Samba - Mailing list pgsql-general

From Doug McNaught
Subject Re: libpq usage in Samba
Date
Msg-id 87u0mtp47x.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to libpq usage in Samba  (Fernando Schapachnik <fernando@mecon.gov.ar>)
List pgsql-general
Fernando Schapachnik <fernando@mecon.gov.ar> writes:

> I'm trying to figure out why Samba is failing at high loads if using
> Postgres as a backend (7.3.9 in my setup). On startup in makes one
> connection only against the database which is shared among all the
> Samba processes. In turn, each issue a PQexec() over the same
> connection (a SELECT, actually). Is that a safe use? I would think
> it is not, but not really sure. I mean, does libpq multiplex queries
> and handle concurrency correctly in a such a scenario?

No, it doesn't.  You need to figure out a way to have each Samba
process open its own connection.

-Doug

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: plperl doesn't release memory
Next
From: "Peterson, Bjorn"
Date:
Subject: Re: Zombie processes