Re: [HACKERS] Checksums by default?
От | Tsunakawa, Takayuki |
---|---|
Тема | Re: [HACKERS] Checksums by default? |
Дата | |
Msg-id | 0A3221C70F24FB45833433255569204D1F6786AC@G01JPEXMBYT05 обсуждение исходный текст |
Ответ на | [HACKERS] Checksums by default? (Magnus Hagander <magnus@hagander.net>) |
Список | pgsql-hackers |
From: pgsql-hackers-owner@postgresql.org > [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Magnus Hagander > Is it time to enable checksums by default, and give initdb a switch to turn > it off instead? > > I keep running into situations where people haven't enabled it, because > (a) they didn't know about it, or (b) their packaging system ran initdb > for them so they didn't even know they could. And of course they usually > figure this out once the db has enough data and traffic that the only way > to fix it is to set up something like slony/bucardo/pglogical and a whole > new server to deal with it.. (Which is something that would also be good > to fix -- but having the default changed would be useful as well) +10 I was wondering why the community had decided to turn it off by default. IIRC, the reason was that the performance overheadwas 20-30% when the entire data directory was placed on the tmpfs, but it's not as important as the data protectionby default. Regards Takayuki Tsunakawa
В списке pgsql-hackers по дате отправления: