Postgres Pro
Downloads
Home   >   mailing lists

A doubt w.r.t WAL - Mailing list pgsql-general

From Shridhar Daithankar
Subject A doubt w.r.t WAL
Date
Msg-id 200307212002.27444.shridhar_daithankar@nospam.persistent.co.in
Whole thread Raw
Responses Re: A doubt w.r.t WAL
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: psql and toggles
Next
From: Tom Lane
Date:
Subject: Re: Checkpoint question