From: | "Hanan Bentaleb" <Hanan(dot)Bentaleb(at)simplernetworks(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Management of Concurrent Clients |
Date: | 2006-02-26 17:39:28 |
Message-ID: | 23BEE0D8F55D0747A13EFE0A6937FFA191CF3A@simnet.simplernetworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I am working on an application that involves multiple processes
accessing and updating different databases: tables are split into 3
different databases that are accessed by 3 different processes. This
architectural decision was made in the past because it has been noticed
that former revisions of postgres used to lock the whole database when a
process performs an update (on a record) which prevents the other
processes from accessing the database.
After some readings on postgres concurrent client management, I am
planning on changing the database structure to make all application
processes access a shared database (i.e. put all application tables in a
single database that would be shared among the 3 processes). I did not
find in the documentation (at least in the current versions of postgres
starting from revision 7) any specific problem related to doing this,
comments on this problem will be appreciated.
Thanks!
Hanan
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-02-26 17:41:20 | Re: createuser permssion for group |
Previous Message | Karsten Hilbert | 2006-02-26 17:34:23 | Re: Wish: remove ancient constructs from Postgres |