Re: [PERFORM] Bad n_distinct estimation; hacks suggested? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Date
Msg-id 200504261345.54164.josh@agliodbs.com
Whole thread Raw
In response to Re: [PERFORM] Bad n_distinct estimation; hacks suggested?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon,

> Could it be that we have overlooked this simple explanation and that the
> Haas and Stokes equation is actually quite good, but just not being
> applied?

That's probably part of it, but I've tried Haas and Stokes on a pure random
sample and it's still bad, or more specifically overly conservative.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?
Next
From: Simon Riggs
Date:
Subject: Re: [PERFORM] Bad n_distinct estimation; hacks suggested?