By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,591 Members | 650 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,591 IT Pros & Developers. It's quick & easy.

Is commit() operation delay is possible due to indexing/vaccuming of database when DB

P: 1
I am using postgres 8.1 version with read commited isolation level. I am getting a problem where vaccuming/indexing of database is running and at the same time update query is invoked and after that commit() for database query is run. Here commit() operation is delayed and seems success i.e. 0 is returned even before completion of commit() operation, commit() get completed after around 1 minute of returning success or 0.
DBI->Do is used for database operations.
Is commit() operation delay possible due to indexing/vaccuming of database and can 0 be returned as result even before completion of commit() operation in case commit() is delayed?
Aug 6 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.