newbie question: 'multithreading' longrunning postgres-queries from plpgsql-function.

From: Erwin Moller <erwin(at)_removespam_dexus(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: newbie question: 'multithreading' longrunning postgres-queries from plpgsql-function.
Date: 2003-03-14 12:52:10
Message-ID: 3E71D07A.2090508@_removespam_dexus.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric Audet 2003-03-14 14:16:42 No aswer WAS: Droping a database even if someone is con nected
Previous Message Pablo Sajnn 2003-03-14 12:26:16 Re: Redefining LIKE operator