From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Checksums by default? |
Date: | 2017-01-25 20:14:58 |
Message-ID: | 1a727de2-e966-36c9-ae01-5bbb6ba3039b@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 01/25/2017 11:41 AM, Tom Lane wrote:
> Stephen Frost <sfrost(at)snowman(dot)net> writes:
>> Would you say that most user's databases run fast enough with checksums
>> enabled? Or more than most, maybe 70%? 80%? In today's environment,
>> I'd probably say that it's more like 90+%.
>
> It would be nice if there were some actual evidence about this, rather
> than numbers picked out of the air.
>
>> I agree that it's unfortunate that we haven't put more effort into
>> fixing that- I'm all for it, but it's disappointing to see that people
>> are not in favor of changing the default as I believe it would both help
>> our users and encourage more development of the feature.
>
> I think the really key point is that a whole lot of infrastructure work
> needs to be done still, and changing the default before that work has been
> done is not going to be user-friendly. The most pressing issue being the
> difficulty of changing the setting after the fact. It would be a *whole*
> lot easier to sell default-on if there were a way to turn it off, and yet
> you want us to buy into default-on before that way exists. Come back
> after that feature is in, and we can talk.
+1
Sincerely,
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2017-01-25 20:17:32 | Re: pg_ls_dir & friends still have a hard-coded superuser check |
Previous Message | Claudio Freire | 2017-01-25 20:11:13 | Re: Vacuum: allow usage of more than 1GB of work mem |