| From: | Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Full page writes improvement |
| Date: | 2007-02-01 02:07:27 |
| Message-ID: | 45C14B5F.4010406@oss.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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.
Implementation:
(1) Mark WAL record whose full-page-writes can be removed,
(2) Remove full-page writes from the marked WAL record in archive
command, and
(3) Restore the removed full-page writes to make LSN consistent.
Included is a patch for this as well as archive and restore command source.
Patch is very small and I hope this to be included in 8.3.
--
Koichi Suzuki
| Attachment | Content-Type | Size |
|---|---|---|
| pg_lesslog.tar.gz | application/gzip | 34.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Sherry | 2007-02-01 02:24:41 | Re: Data archiving/warehousing idea |
| Previous Message | Chris Dunlop | 2007-02-01 02:01:34 | Data archiving/warehousing idea |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-02-01 02:38:36 | Re: DROP FUNCTION failure: cache lookup failed for relation X |
| Previous Message | Mark Kirkwood | 2007-02-01 01:17:24 | Re: [pgsql-patches] Patch to avoid gprof profiling overwrites |