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: 2007-04-26 10:08:08
Message-ID: 46307A08.2060803@logotronic.co.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joe Conway 2007-04-26 10:16:35 Re: custom crosstab question
Previous Message Liliana Matos 2007-04-26 09:55:23 Re: pg_dump