Re: PATCH: adaptive ndistinct estimator v4

From: Greg Stark <stark(at)mit(dot)edu>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: adaptive ndistinct estimator v4
Date: 2015-04-03 13:46:45
Message-ID: CAM-w4HPta0Jhcv2q5vhwGJ6oL_=Fe1rz9NEkn-3+2W0+UzWR2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

> The simple workaround for this was adding a fallback to GEE when f[1] or
f[2] is 0. GEE is another estimator described in the paper, behaving much
better in those cases.

For completeness, what's the downside in just always using GEE?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-04-03 14:01:23 Re: Possibly a typo in expand_inherited_rtentry()
Previous Message Andrew Gierth 2015-04-03 13:06:42 Re: Abbreviated keys for Numeric

Browse pgsql-performance by date

  From Date Subject
Next Message Pietro Pugni 2015-04-03 13:55:04 Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Previous Message Pietro Pugni 2015-04-03 13:43:02 Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL