Re: BRIN index bug due to WAL refactoring

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BRIN index bug due to WAL refactoring
Дата
Msg-id 20150626183524.GS3289@postgresql.org
обсуждение исходный текст
Ответ на BRIN index bug due to WAL refactoring  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: BRIN index bug due to WAL refactoring  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Jeff Janes wrote:

> On replica:
>
> set enable_seqscan TO off;
> explain (analyze) select count(*) from foobar ;
> ERROR:  corrupted BRIN index: inconsistent range map

Nice.  As I understand it, the problem is that the replay is using the
block number of the revmap page as target blkno of the revmap entry,
when it should be using the block number of the data page.  This should
fix it.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Вложения

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: PANIC in GIN code
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: Re: Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?