Re: estimating # of distinct values - Mailing list pgsql-hackers

From Robert Haas
Subject Re: estimating # of distinct values
Date
Msg-id AANLkTi=B90S8Whyk5KN13wJw1gqJ3UzSiJiQCHhYAONa@mail.gmail.com
Whole thread Raw
In response to Re: estimating # of distinct values  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
On Wed, Jan 19, 2011 at 9:35 PM, Florian Pflug <fgp@phlo.org> wrote:
> Also, in my personal experience this isn't really the area we've got
> problems now. The problem cases for me always were queries with a rather
> large number of joins (7 to 10 or so) plus rather complex search
> conditions. The join order, not the access strategy, then becomes the
> deciding factor in plan performance.

This certainly matches my experience (except sometimes with more joins).

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: estimating # of distinct values
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE ... REPLACE WITH