Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix
Дата
Msg-id 957A97A0-73D7-4F53-B34A-E086AEC80596@icloud.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-admin

> On Jun 12, 2018, at 12:16 PM, Peter Geoghegan <pg@bowt.ie> wrote:
>
> On Tue, Jun 12, 2018 at 8:21 AM, Rui DeSousa <rui.desousa@icloud.com> wrote:
>> Note that DBCC was never a selling point and neither is fsck; the fact that those tools are needed is a problem.
>
> DBCC is a selling point. "Parallel consistency check" is a feature
> that is only available in SQL Server enterprise edition.

That’s not what I recall; it was clearly used against it in sales pitches.  Do you really want to trust a database that
requiresyou to DBCC checkdb periodically and fix corruption data pages or do you want to trust Oracle with data? 

Would you use a filesystem today that required you to fsck after a crash?

Sure DBCC has useful features like tracing, etc. — it’s not just for corruption.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix