I am trying to understand the way in which PostgreSQL creates, updates
and uses the transaction log.
I browsed through the sources and what I understand is that, when we
"initdb", the "initdb" binary reads postgres.bki which is created by
But I fail to understand how data is stored (written) in the
"000001xxxxx" file. I came across some CRC and compression code.
I used a hexeditor to deciphar the contents of "000001xxxx" file but
it was not of much help.
Are the query (inserts/updates) put as is in the transaction log file ?
Does the CRC and compression logic transform the query ?
While we do a recovery, does it backtrace these CRC and compression
logic to retrieve the query ?
pgsql-hackers by date
|Next:||From: Marian POPESCU||Date: 2005-03-31 08:23:59|
|Subject: Re: ARC patent|
|Previous:||From: Neil Conway||Date: 2005-03-31 06:56:52|
|Subject: Re: [HACKERS] contrib/pg_buffercache|