Re: Overriding the optimizer - Mailing list pgsql-performance

From Craig A. James
Subject Re: Overriding the optimizer
Date
Msg-id 43A23079.8060307@modgraph-usa.com
Whole thread Raw
In response to Re: Overriding the optimizer  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Overriding the optimizer
List pgsql-performance
Christopher Kings-Lynne wrote:
> Can you paste explain analyze and your effective_cache_size, etc. settings.
> ...
> This seems like a case where PostgreSQL's current optimiser should
> easily know what to do if your config settings are correct and you've
> been running ANALYZE, so I'd like to see your settings and the explain
> analyze plan...

I could, but it would divert us from the main topic of this discussion.  It's not about that query, which was just an
example. It's the larger issue. 

Tom's earlier response tells the story better than I can:
> This discussion has been had before (many times) ... see
> the -hackers archives for detailed arguments.

If it's "been had before (many times)", and now I'm bringing it up again, then it's clearly an ongoing problem that
hasn'tbeen resolved. 

Craig

pgsql-performance by date:

Previous
From: "Craig A. James"
Date:
Subject: Re: Overriding the optimizer
Next
From: Mark Kirkwood
Date:
Subject: Re: Overriding the optimizer