473,386 Members | 1,820 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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

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
0 1198

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

Similar topics

2
by: Ron Sellers | last post by:
I have built a VB.Net app that runs fine when the Windows desktop resolution is set to normal (100%). When the Display Properties>Settings>Advanced>Display>Font Size is set to "Large Fonts"...
1
by: Magnus | last post by:
I have created an application with VB in Visual Studio .Net. The application use a SQL server as database. Can anyone explain how I include the database when i make a setup for my application?...
3
by: lieven.becue | last post by:
Situation: at work we have a windows 2003 server with MS sql server 2005 express. With my pc at work, I can see my own database I created. At home. I can connect with VPN to the network. With...
12
by: Birky | last post by:
How can I stop a form from updating the database when a user closes the form? I have a form which is used for referencing, additions, and modifications but every time the form is closed with no...
2
by: Divas | last post by:
Dear Sir Please help me for below question. How check the System.DbNull values from database when we retrive the data from databa Thanx
3
by: Max2006 | last post by:
Hi, I have a search result GridView bound to an ObjectDataSource. Once I open the asp.net page, the ObjectDataSource automatically refreshes the GridView which is the default behavior. I am...
10
by: loisk | last post by:
Hi, After our server 'wiped out' adversity by someone, we re-installed all the necessary mysql files. I am trying to separate my working database folder from the mysql program folder, and I want...
1
by: adsaca | last post by:
here's my code in filling a datagridview,which i retrieve from database mysql, dim sql as String sql = "SELECT * FROM table_user" Dim myData As New DataTable ...
0
by: KishorDhembare | last post by:
Hi Everybady I Want To Create New Database When My Application Starts First Time My Application Developed In Vb.net I Get The Error When I Run Command which I Have Command Is Like. Dim...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.