#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    1
    Rep Power
    0

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


    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?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,785
    Rep Power
    348
    Stop using 8.1 and upgrade to a supported version now. There were massive bugfixes and (performance) enhancements to the vacuum implementation in the last 8 years.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

IMN logo majestic logo threadwatch logo seochat tools logo