The following bug has been logged on the website:
Bug reference: 8381
Logged by: Rohit Gupta
Email address: rohit.guptakec@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)