Re: BRIN index and aborted transaction - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: BRIN index and aborted transaction
Date
Msg-id 20150724.080603.2015706061674185310.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: BRIN index and aborted transaction  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: BRIN index and aborted transaction
List pgsql-hackers
> Hm, well, I am not sure that we want to pay the overhead of
> re-summarization every time we prune a single tuple from a block range.
> That's going to make vacuum much slower, I assume (without measuring);
> many page ranges are going to be re-summarized without this actually
> changing the range.

What I'm interested in is, if there's a case that using BRIN index is
slower than plain sequential scan (or planner is stupid enough to
choose BRIN index scan over sequential scan even if the former is
slower).

If such that case exists, we may want to fix it before releasing 9.5.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TABLESAMPLE patch is really in pretty sad shape
Next
From: Tatsuo Ishii
Date:
Subject: Re: Planner debug views