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

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Robert Haas <robertmhaas@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: PATCH: adaptive ndistinct estimator v4
Date: Fri, 15 May 2015 12:35:50 -0700
Message-ID: <55564A96.7040506@agliodbs.com> (raw)
In-Reply-To: <WM!de8c487c7acd0ce97fa1867eca3bd6d9621ef2044834973f21e5cd6c45f43a210654790359d4c50fe70c697b68ef7d0f!@asav-2.01.com>
References: <541A2335.3060100@agliodbs.com>
	<CAEYLb_UTz=dtxYOCYF_D1s7wQJfoZUrey6Fjxq08VFueXWoEKQ@mail.gmail.com>
	<WM!341e0135c2f371f48830484cdb3da37506d776453b10db7a9af11d648214c4b437402f04e7ccb3d30918cbc64dfee95d!@asav-1.01.com>
	<542DADEB.2080103@agliodbs.com>
	<CAM-w4HNfZymQmTu3+TxQQD-e6_410-sDnZBaW8neurmTFh4GbA@mail.gmail.com>
	<f4c06746b31e468f9550fb9924798da3.squirrel@2.emaily.eu>
	<54381D20.9010501@fuzzy.cz>
	<CAMkU=1yoiQt6+_XMACL=PTv-aHwc1E0BgiHGhKW3HL+ByN6zpw@mail.gmail.com>
	<5472416C.3080506@fuzzy.cz>
	<5483B346.6000203@fuzzy.cz>
	<551AEF45.7010700@2ndquadrant.com>
	<CA+TgmoaCsdM5WSpaVNmbWBN8+wuOGfYt1reZttGmDG1CnJvtLQ@mail.gmail.com>
	<5542D4CF.5060700@2ndquadrant.com>
	<CAMkU=1yR=i5F1RnmJsB9C-iEbTE3J1sR+4mRbcPy6mwCotPxfQ@mail.gmail.com>
	<CA+TgmoZ6FgvwVTyzM7hLiHDifYinXKsTiRWxh062AETOt8Dw7Q@mail.gmail.com>
	<WM!de8c487c7acd0ce97fa1867eca3bd6d9621ef2044834973f21e5cd6c45f43a210654790359d4c50fe70c697b68ef7d0f!@asav-2.01.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 05/15/2015 11:30 AM, Robert Haas wrote:
> Once we enter beta (or even feature freeze), it's too late to whack
> around the algorithm heavily.  We're pretty much committed to
> releasing and supporting whatever we have got at that point.  I guess
> we could revert it if it doesn't work out, but that's about the only
> option at that point.  We have more flexibility during the main part
> of the development cycle.  But your point is certainly valid and I
> don't mean to dispute it.

I will finally have a customer workload available to test this on this
weekend.  That's been rather delayed by the availability of customer
hardware,because I'm not allowed to copy out the database.  However,
this is a database which suffers from multiple ndistinct estimation
issues in production, so I should be able to get a set of stats back by
Monday which would show how much of a general improvement it is.

I realize that's after the deadline, but there wasn't much I could do
about it.  I've tried to simulate the kind of estimation issues I've
seen, but they don't simulate well.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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



view thread (17+ messages)  latest in thread

Message-ID: <55564A96.7040506@agliodbs.com>
Permalink:  ../55564A96.7040506@agliodbs.com/
Also on:    postgresql.org/message-id/55564A96.7040506@agliodbs.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: josh@agliodbs.com, robertmhaas@gmail.com, jeff.janes@gmail.com, tomas.vondra@2ndquadrant.com, pgsql-hackers@postgresql.org
  Subject: Re: PATCH: adaptive ndistinct estimator v4
  In-Reply-To: <55564A96.7040506@agliodbs.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