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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Doug Knight | 2007-02-01 20:14:48 | Re: pg_standby |
Previous Message | Bruce Momjian | 2007-02-01 19:14:07 | Re: pg_restore fails with a custom backup file |
From | Date | Subject | |
---|---|---|---|
Next Message | Doug Knight | 2007-02-01 20:14:48 | Re: pg_standby |
Previous Message | Bruce Momjian | 2007-02-01 18:40:58 | Re: [pgsql-patches] Recalculating OldestXmin in a long-running vacuum |