Skip site navigation (1)
Skip section navigation (2)
I would like to know how long it will take until the effects of a transaction is visible from outside after a commit statement. Or in other words: I have the situation that i have to use data which is inserted within a transaction immediately after the transactions is committed, but sometimes the new data is not available a this moment (A few moments later it is available). Is there any method to check if data is ready to be used before 'selecting' it?
Peripheral Links
Header And Logo
|
Site Navigation
How long does commit take?
- From: Reinhard Hnat <hnat(at)logotronic(dot)co(dot)at>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: How long does commit take?
- Date: Thu, 26 Apr 2007 12:08:08 +0200
I would like to know how long it will take until the effects of a transaction is visible from outside after a commit statement. Or in other words: I have the situation that i have to use data which is inserted within a transaction immediately after the transactions is committed, but sometimes the new data is not available a this moment (A few moments later it is available). Is there any method to check if data is ready to be used before 'selecting' it?
-- R.Hnat
- Follow-Ups:
- Re: How long does commit take?
- From: Tom Lane
- Re: How long does commit take?
- Prev by Date: Re: custom crosstab question
- Next by Date: pg_dump slave DB
- Previous by thread: cannot insert or update
- Next by thread: Re: How long does commit take?
- Indexes: