Re: Estimation issue with partitioned tables - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Estimation issue with partitioned tables
Date
Msg-id 4B93E906.5030804@agliodbs.com
Whole thread Raw
In response to Re: Estimation issue with partitioned tables  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Estimation issue with partitioned tables
List pgsql-performance
Robert,

>> Yeah, I can generate one pretty easily; the behavior is readily
>> observable and repeatable.  Will get on it RSN, but at you said, we're
>> not doing anything about it for 9.0.

Well, I can generate a test case, but on examination it turns out to be
nothing to do with partitioning; it's just good old "n-distinct
underestimation", and not really related to partitioning or joins.

--Josh Berkus

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: partition pruning
Next
From: Devrim GÜNDÜZ
Date:
Subject: Testing FusionIO