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

Re: Full page writes improvement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp>
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>,pgsql-patches(at)postgresql(dot)org
Subject: Re: Full page writes improvement
Date: 2007-02-01 19:59:07
Message-ID: 23241.1170359947@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp> writes:
> Here's an idea and a patch for full page writes improvement.

> Idea:
> (1) keep full page writes for ordinary WAL, make them available during
> the crash recovery, -> recovery from inconsistent pages which can be
> made at the crash,
> (2) Remove them from the archive log except for those written during
> online backup (between pg_start_backup and pg_stop_backup) -> small size
> archive log.

Doesn't this break crash recovery on PITR slaves?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Doug KnightDate: 2007-02-01 20:14:48
Subject: Re: pg_standby
Previous:From: Bruce MomjianDate: 2007-02-01 19:14:07
Subject: Re: pg_restore fails with a custom backup file

pgsql-patches by date

Next:From: Doug KnightDate: 2007-02-01 20:14:48
Subject: Re: pg_standby
Previous:From: Bruce MomjianDate: 2007-02-01 18:40:58
Subject: Re: [pgsql-patches] Recalculating OldestXmin in a long-running vacuum

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