Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] Full page writes improvement, code update

From: "Koichi Suzuki" <koichi(dot)szk(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] Full page writes improvement, code update
Date: 2007-03-31 00:37:01
Message-ID: a778a7260703301737l486aa5ebo830f0ac269a1fb15@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Simon;
Tom;

Koichi is writing.

Your question is how to determine WAL record generated between
pg_start_backup and pg_stop_backup and here's an answer.

XLogInsert( ) already has a logic to determine if inserting WAL record
is between pg_start_backup and pg_stop_backup.   Currently it is used
to remove full_page_writes when full_page_writes=off.   We can use
this to mark WAL records.   We have one bit not used in WAL record
header, the last bit of xl_info, where upper four bits are used to
indicate the resource manager and three of the rest are used to
indicate number of full page writes included in the record.

So in my proposal, this unused bit is used to mark that full page
writes must not be removed at offline optimization by pg_complesslog.

Sorry I didn't have mailing list capability from home and have just
completed my subscription from
home.   I had to create new thread to continue my post.  Sorry for confusion.

Please refer to the original thread about this discussion.

Best Regards;

-- 
------
Koichi Suzuki

pgsql-hackers by date

Next:From: Gregory StarkDate: 2007-03-31 00:46:34
Subject: Re: Last minute mini-proposal (I know, I know) for PQexecf()
Previous:From: Tom LaneDate: 2007-03-31 00:30:22
Subject: Re: Last minute mini-proposal (I know, I know) for PQexecf()

pgsql-patches by date

Next:From: David FetterDate: 2007-03-31 05:37:50
Subject: Re: Fwd: Re: [pgsql-patches] pg_get_domaindef
Previous:From: Florian G. PflugDate: 2007-03-30 22:51:36
Subject: Re: Minor changes to Recovery related code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group