Re: Odd, intermittent failure in contrib/pageinspect

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd, intermittent failure in contrib/pageinspect
Дата
Msg-id 416876.1611010060@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Odd, intermittent failure in contrib/pageinspect  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> On 2021-Jan-18, Tom Lane wrote:
>> [ thinks for a bit... ]  Does the checkpointer pin pages it's writing
>> out?  I guess it'd have to ...

> It does, per SyncOneBuffer(), called from BufferSync(), called from
> CheckPointBuffers().

Right, then we don't need any strange theories about autovacuum,
just bad timing luck.  whelk does seem pretty slow, so it's not
much of a stretch to imagine that it's more susceptible to this
corner case than faster machines.

So, do we have any other tests that are invoking a manual vacuum
and assuming it won't skip any pages?  By this theory, they'd
all be failures waiting to happen.

            regards, tom lane



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

Предыдущее
От: Tom Kincaid
Дата:
Сообщение: Re: Key management with tests
Следующее
От: Massimo Fidanza
Дата:
Сообщение: Re: [WIP] UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR