Re: blocking function in PL/Python - Mailing list pgsql-general

From Richard Huxton
Subject Re: blocking function in PL/Python
Date
Msg-id 45542ADA.2030602@archonet.com
Whole thread Raw
In response to blocking function in PL/Python  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
Ottavio Campana wrote:
> suppose we have a stored procedure written in PL/Python.
>
> What happens if the function blocks for a while?
>
> Does the server still works for the other clients?

Yes. Each client has its own backend process.

Although, if you've taken locks that might block other clients.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: AutoVacuum on demand?
Next
From: Richard Huxton
Date:
Subject: Re: postgres at startup