newbie question: 'multithreading' longrunning postgres-queries from plpgsql-function. - Mailing list pgsql-general

From Erwin Moller
Subject newbie question: 'multithreading' longrunning postgres-queries from plpgsql-function.
Date
Msg-id 3E71D07A.2090508@_removespam_dexus.nl
Whole thread Raw
Responses Re: newbie question: 'multithreading' longrunning postgres-queries from plpgsql-function.  (P G <pg_dba@yahoo.com>)
List pgsql-general
Hi Group,


If a function (plpgsql in Postgres7.3) takes a long while to complete,
and only performs updates on tables, will other connections to the same
database just continue to function normally?

I understand that normal longrunning queries will run simultaniously,
but does that apply to plpgsql-functions too?

I need to know a little bit more about 'multithreading' in Postgres
before coding my application that way.
(I am not sure 'multithreading' is the right choice of words for the
describted situation.)

Thanks.

Regards,
Erwin


pgsql-general by date:

Previous
From: "Daniel R. Anderson"
Date:
Subject: Re: configuration according to the database
Next
From: "Daniel R. Anderson"
Date:
Subject: Re: data transfer between databases