Re: Oddball data distribution giving me planner headaches

From: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org, David Johnston <polobo(at)yahoo(dot)com>
Subject: Re: Oddball data distribution giving me planner headaches
Date: 2011-12-02 21:15:28
Message-ID: 1322860528.3654.YahooMailClassic@web65511.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- On Fri, 12/2/11, David Johnston <polobo(at)yahoo(dot)com> wrote:

> What happens if you disable, say, nested loops and/or index
> scans?

planner selects different join/indexing techniques (query is slower) but row estimates (bad) remain identical.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-12-02 21:28:13 Re: Oddball data distribution giving me planner headaches
Previous Message David Johnston 2011-12-02 21:04:08 Re: Oddball data distribution giving me planner headaches