From: | Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, koichi(dot)szk(at)gmail(dot)com, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Subject: | Re: Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released |
Date: | 2010-05-13 05:23:48 |
Message-ID: | 20100513142347.A1CF.52131E4D@oss.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-bugs pgsql-general pgsql-hackers |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Yes, I would love to get this into /contrib for PG 9.1!
>
> How much are people really going to care about pg_lesslog now that
> we've got streaming replication? There might be some small use-case
> still left, but it's hard to believe that it would be worth carrying
> it in contrib.
I hope pg_lesslog would work as a WAL filter of streaming replication.
It might be hard-coded in WAL sender, or be an addon based on a new
common filtering infrastructure of WAL streaming.
Also, there is a long-standing issue in pg_lesslog; It slows down recovery
because we need to read data pages before write in recovery. We're avoiding
reading pages for full-page image in 8.3, but pg_lesslog will disable
the optimization. Recovery routine in core also needs to be adjusted to use
read-ahead, like posix_fadvise().
There was another idea, full-page image logs separated with WAL logging.
In theory, full-page images don't have to be written at commit, but only
by writing corresponding data pages, I'm not sure whether it is an actually
good idea or not, but if we go the direction, we won't need pg_lesslog.
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Koichi Suzuki | 2010-05-13 06:13:35 | Re: Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released |
Previous Message | Josh Berkus | 2010-05-12 21:26:34 | Re: Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released |
From | Date | Subject | |
---|---|---|---|
Next Message | Koichi Suzuki | 2010-05-13 06:13:35 | Re: Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released |
Previous Message | Josh Berkus | 2010-05-12 21:26:34 | Re: Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released |
From | Date | Subject | |
---|---|---|---|
Next Message | Koichi Suzuki | 2010-05-13 06:13:35 | Re: Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released |
Previous Message | Tom Lane | 2010-05-13 04:33:08 | Re: Pulling data from a constraint def |
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2010-05-13 05:28:15 | Re: recovery getting interrupted is not so unusual as it used to be |
Previous Message | Jan Wieck | 2010-05-13 04:24:47 | Retiring from the PostgreSQL core team |