A doubt w.r.t WAL

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: A doubt w.r.t WAL
Date: 2003-07-21 14:32:27
Message-ID: 200307212002.27444.shridhar_daithankar@nospam.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a doubt regarding WAL.

Let's say I have only one wAL segment of 16MB and in a single transaction I
put 20MB of data, say a text file dump inside a transaction.

How does WAL handles this situation from POV of using/reusing WAL space and
ensuring consistency of data in table?

Does it record committed/uncommitted transaction id in clog and safely start
pushing data into data files?

Shridhar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-21 14:41:01 Re: Checkpoint question
Previous Message u15074 2003-07-21 14:24:36 Re: Checkpoint question