On Sun, Aug 11, 2013 at 08:06:55AM +0000, rohit.gupta...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 8381 > Logged by: Rohit Gupta > Email address: rohit.gupta...@gmail.com > PostgreSQL version: Unsupported/Unknown > Operating system: linux > Description: > > Background:- There were a large no. of INSERT/UPDATE/DELETE operation being > performed on DB. The DB is reindex/vacuum every hour. > During reindex/vacuum time one of the DB table value was successfully > updated. But later the read query after ~30 seconds read previous values. Is > this possible that the update query commit is delayed ? Are there are some > known issues of commit during reindex/vacuum. > Currently we are using DB version 8.1 > Later when we check the DB status (after some days)it was having the correct > updated values. > We are using default isolation level (Read Committed)
PostgreSQL 8.1 has been unsupported since 2010. Once you've upgraded to a supported version, if the problem persists, we may be able to help. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs