pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Evgeniy Shishkin <itparanoia@gmail.com>
To: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Yet another abort-early plan disaster on 9.3
Date: Thu, 5 Nov 2015 12:45:31 +0300
Message-ID: <AFB7BFDE-AFD6-4961-BEA0-EFF686E4264E@gmail.com> (raw)
In-Reply-To: <CAB7nPqQOOv58JkDf3=7=0GNqFUKkQdC7aE6JZYuPWjXyEyx2Qg@mail.gmail.com>
References: <541A2335.3060100@agliodbs.com>
	<CAHyXU0zSCWLYZ34fsgAGn9x+nFEwOih4ve3kyeYonTY6xG1Xbg@mail.gmail.com>
	<WM!2bfedb9f882c0aee19f96e138ce7ba810dc6737fca13f21c249ba37fd452020e43a863c0516a5aab9c7b1bd4f7201d15!@asav-3.01.com>
	<541C7891.7000902@agliodbs.com>
	<CAM-w4HODbu3jLFbENhUXmU3R6YQUQW2GZQOBzt3vHtVdUO5+hA@mail.gmail.com>
	<WM!1ae41f8d6a3ccc4760aa921f5bee325497ff91ea6bb56959742bfe645e3727f092c347cf598f62aba805d5b6535ebc8f!@asav-1.01.com>
	<541DC87F.3030800@agliodbs.com>
	<CAHyXU0xh8kFG6jiH3CLswTPiZTxJYsP==uaZP_w_FxHc0Kyqxg@mail.gmail.com>
	<WM!aa8d66f3329082c248d8e57896b3051be5691fe6550231e4f7388b7a9339864c4c89748426e4ef897c484b8998b7f996!@asav-1.01.com>
	<5420B71C.6010208@agliodbs.com>
	<CA+U5nMJqYiViG8Xu=OqJo5o7NbKgrBYC=Kn6nx-4AtKXidWvtw@mail.gmail.com>
	<CAHyXU0wFAKiwgybbEAX=597-MxtPGdf0bmQvRSJq9db1KTZ6nA@mail.gmail.com>
	<CA+U5nMKnwZVkvdaQP7Sm15-Emdwt+TgnW7-0xQJvZPtHu2Wsvw@mail.gmail.com>
	<13982.1412031637@sss.pgh.pa.us>
	<CA+U5nMKkHU7V_QVLD0uREy42_7ET_QAXWgc2UYJBnTesNkbH7A@mail.gmail.com>
	<CA+U5nMJXYFVr_OUyU45W-q6BX=0H6K9DsSXFA4QZcoBzTO0WKA@mail.gmail.com>
	<CA+U5nMJqbcveiVL=cMCkzvOzSqPHytPROTbUnw8W6YRC=8T3Vw@mail.gmail.com>
	<CA+U5nMK5oDBVeadzK3VQHF8JBEMW3+jFWds-KP2N449kedkp0w@mail.gmail.com>
	<CAB7nPqQOOv58JkDf3=7=0GNqFUKkQdC7aE6JZYuPWjXyEyx2Qg@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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. 

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (60+ messages)

Message-ID: <AFB7BFDE-AFD6-4961-BEA0-EFF686E4264E@gmail.com>
Permalink:  ../AFB7BFDE-AFD6-4961-BEA0-EFF686E4264E@gmail.com/
Also on:    postgresql.org/message-id/AFB7BFDE-AFD6-4961-BEA0-EFF686E4264E@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: itparanoia@gmail.com
  Subject: Re: Yet another abort-early plan disaster on 9.3
  In-Reply-To: <AFB7BFDE-AFD6-4961-BEA0-EFF686E4264E@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox