Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZuH8f-0003V5-Oh for pgsql-performance@arkaria.postgresql.org; Thu, 05 Nov 2015 09:47:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZuH8f-0002cx-6r for pgsql-performance@arkaria.postgresql.org; Thu, 05 Nov 2015 09:47:25 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZuH71-0000mq-9I for pgsql-performance@postgresql.org; Thu, 05 Nov 2015 09:45:43 +0000 Received: from mail-lf0-x22b.google.com ([2a00:1450:4010:c07::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZuH6u-0008Eo-2d for pgsql-performance@postgresql.org; Thu, 05 Nov 2015 09:45:41 +0000 Received: by lfgh9 with SMTP id h9so54824710lfg.1 for ; Thu, 05 Nov 2015 01:45:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date :content-transfer-encoding:message-id:references:to; bh=Q83dxL10ic683TSivktmNfHmUUCZHQF42lP5r7nBRgs=; b=IqMvQWntfEbW5y7uFm/peKHa/BJ2WoKlDXijOo8rX6n2SUJfQw6MCWXGEfWxjoiPhH hY6eCGTpWPaFTEn+6Or6jtqSOSWobxSZWKXcfpS3bVvY+S41Xsyaa3QnZyR30sG+uDRy KOL2G1rlb8oiJ4axHWgmD4qK1Rbf/N+qXiAt9U6lbWPC4zGwP0ZKcSLqAjw44PKuWPtC +XiB4g0tWTEfexNsePCyRXku+/nwr0B85X72+HM2v9x349fUaUiGV5dMpJ3ufly4kozG b0ycTyk/zahTEZ2pD8G7UhQZERd7PtNYLkAYHEsPNnCsJFa1fdsrXxcqeX9Tvo3OY9vi emzw== X-Received: by 10.25.137.214 with SMTP id l205mr1701240lfd.69.1446716733872; Thu, 05 Nov 2015 01:45:33 -0800 (PST) Received: from wgaybook.corp.wargaming.local (by1-office.wargaming.net. [178.172.239.244]) by smtp.gmail.com with ESMTPSA id o197sm849488lfb.7.2015.11.05.01.45.32 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Thu, 05 Nov 2015 01:45:33 -0800 (PST) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Mac OS X Mail 9.1 \(3096.5\)) Subject: Re: Yet another abort-early plan disaster on 9.3 From: Evgeniy Shishkin In-Reply-To: Date: Thu, 5 Nov 2015 12:45:31 +0300 Content-Transfer-Encoding: quoted-printable Message-Id: References: <541A2335.3060100@agliodbs.com> <541C7891.7000902@agliodbs.com> <541DC87F.3030800@agliodbs.com> <5420B71C.6010208@agliodbs.com> <13982.1412031637@sss.pgh.pa.us> To: postgres performance list X-Mailer: Apple Mail (2.3096.5) X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Sorry for disrupting the thread, i am wondering will it be possible to use BRIN indexes to better estimate d= istribution? I mean create btree index and brin index, probe brin during planning and estimate if abort early plan with btree will= be better.=20 --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance