Postgres Pro
Downloads
Home   >   mailing lists

Re: Oddball data distribution giving me planner headaches - Mailing list pgsql-general

From Jeff Amiel
Subject Re: Oddball data distribution giving me planner headaches
Date
Msg-id 1322860528.3654.YahooMailClassic@web65511.mail.ac4.yahoo.com
Whole thread Raw
In response to Re: Oddball data distribution giving me planner headaches  ("David Johnston" <polobo@yahoo.com>)
Responses Re: Oddball data distribution giving me planner headaches
List pgsql-general
Tree view 

--- On Fri, 12/2/11, David Johnston <polobo@yahoo.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.

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Oddball data distribution giving me planner headaches
Next
From: "David Johnston"
Date:
Subject: Re: Oddball data distribution giving me planner headaches