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) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs