Re: Yet another abort-early plan disaster on 9.3

From: Evgeniy Shishkin <itparanoia(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Yet another abort-early plan disaster on 9.3
Date: 2015-11-05 09:45:31
Message-ID: AFB7BFDE-AFD6-4961-BEA0-EFF686E4264E@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Sorry for disrupting the thread,

i am wondering will it be possible to use BRIN indexes to better estimate distribution?

I mean create btree index and brin index,
probe brin during planning and estimate if abort early plan with btree will be better.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2015-11-05 10:34:50 Re: extend pgbench expressions with functions
Previous Message Amit Langote 2015-11-05 09:32:59 Re: psql completion for ids in multibyte string

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2015-11-05 11:24:24 Re: HASH
Previous Message Artem Tomyuk 2015-11-05 09:11:10 HASH