| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | jd(at)commandprompt(dot)com |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Aidan Van Dyk <aidan(at)highrise(dot)ca>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Block-level CRC checks |
| Date: | 2009-12-01 18:20:08 |
| Message-ID: | 603c8f070912011020v3ac4f003p4532af93cef1973d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Dec 1, 2009 at 1:02 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> The hard core reality is this. *IF* it is one of the goals of this
> project to insure that the software can be safely, effectively, and
> responsibly operated in a manner that is acceptable to C* level people
> in a Fortune level company then we *must* solve this problem.
>
> If it is not the goal of the project, leave it to EDB/CMD/2ndQuandrant
> to fork it because it will eventually happen. Our customers are
> demanding these features.
OK, and when you fork it, how do you plan to implement it? The
problem AFAICS is not that anyone hugely dislikes the feature; it's
that nobody is really clear on how to implement it in a way that's
actually useful.
So far the only somewhat reasonable suggestions I've seen seem to be:
1. WAL-log setting the hint bits. If you don't like the resulting
performance, shut off the feature.
2. Rearrange the page so that all the hint bits are in the first 512
bytes along with the CRC, so that there can be no torn pages. AFAICS,
no one has rendered judgment on whether this is a feasible solution.
Does $COMPETITOR offer this feature?
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2009-12-01 18:22:56 | Re: Block-level CRC checks |
| Previous Message | Robert Haas | 2009-12-01 18:12:18 | Re: Re: [COMMITTERS] pgsql: Rewrite GEQO`s gimme_tree function so that it always finds a |