Re: Estimation issue with partitioned tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Estimation issue with partitioned tables
Date: 2010-03-03 21:45:53
Message-ID: 4B8ED891.7060405@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> I feel like I've seen these way-too-high row estimates in some other
> postings to -performance, but I'm not sure if it was the same issue.
> You don't by chance have a RTC? I don't think it's likely fixed in 9.0
> but it would be interesting to investigate.

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.

I've a feeling that this will become one of the list of issues to be
fixed with 'real partitioning'.

--Josh Berkus

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-03-04 02:07:11 Re: Estimation issue with partitioned tables
Previous Message Robert Haas 2010-03-03 19:33:59 Re: bgwriter, checkpoints, curious (seeing delays)