On Tue, Nov 24, 2009 at 5:38 PM, Michael Lawson (mshindo) <mich...@sphinix.com> 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 same > record is read. > > 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.
What pg version, what's your access patterns look like, and what maintenance like vacuuming / autovacuuming are you doing / not doing? Is this within the same connection, and it's taking 15 seconds for an insert to return? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general