Re: [GENERAL] Processing Delay

2009-11-24 Thread Sam Jas
Lawson (mshindo) wrote: From: Michael Lawson (mshindo) Subject: [GENERAL] Processing Delay To: pgsql-general@postgresql.org Date: Wednesday, 25 November, 2009, 12:38 AM Hi, We have a problem with a relatively small database at the moment that is resulting in delays times between insertions and

Re: [GENERAL] Processing Delay

2009-11-24 Thread Scott Marlowe
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

Re: [GENERAL] Processing Delay

2009-11-24 Thread Christophe Pettus
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

[GENERAL] Processing Delay

2009-11-24 Thread Michael Lawson (mshindo)
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 same record is read. The problem we are encountering is a delay before we