I suspect the issue is with the memories.
Is it possible for you to send us the following details.
(1) size of database you are managing on cluster ?
(2) postgresql.conf file
(3) Total RAM/ SHMMAX
(4) query which is taking more time.
--
Thanks
Sam Jas
--- On Wed, 25/11/09, Michael Lawson
On Tue, Nov 24, 2009 at 5:38 PM, Michael Lawson (mshindo)
wrote:
> Hi,
>
> We have a problem with a relatively small database at the moment that is
> resulting in delays times between insertions and retrievals. An update is
> applied to a single entry in a table and almost straight after that the
On Nov 24, 2009, at 4:38 PM, Michael Lawson (mshindo) wrote:
The problem we are encountering is a delay before we can read the
updated value. This delay can be up to 15 seconds in some cases.
Is the delay a block (that is, you insert the value, and then the
SELECT that should retrieve it ta
