Re: RFC: Add 'taint' field to pg_control.

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: RFC: Add 'taint' field to pg_control.
Дата
Msg-id CAMsr+YH7F+sfpFaK8xumdotgi+7VRP4RVhvP_6RksAHz=kgtgQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: RFC: Add 'taint' field to pg_control.  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
On 1 March 2018 at 09:00, Justin Pryzby <pryzby@telsasoft.com> wrote:
 

> >  - started in single user mode or with system indices disabled?
> why?

Some of these I suggested just as a datapoint (or other brainstorms I couldn't
immediately reject).  A cluster where someone has UPDATED pg_* (even
pg_statistic) or otherwise hacked on I would tend to think about differently
than a "pristine" cluster that's never seen anything more interesting than a
join.


How about "has run in a state where system catalog modifications are permitted". Because I've had one seriously frustrating case where that would've been extremely pertinent information.

That said, I'm not convinced it's worth the effort and I think this is going off into the weeds a little. Lets focus on Andres's core suggestion (and maybe refine the fsync part to get rid of false positives due to bulk loading) and build on from there in subsequent work. 

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Online enabling of checksums
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Online enabling of checksums