pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Craig A. James <cjames@modgraph-usa.com>
To: pgsql-performance@postgresql.org
Subject: Re: Overriding the optimizer
Date: Thu, 15 Dec 2005 19:11:53 -0800
Message-ID: <43A23079.8060307@modgraph-usa.com> (raw)
In-Reply-To: <43A227BE.9030106@familyhealth.com.au>
References: <200512141603.52583.blargity@gmail.com>
	<7484.1134600423@sss.pgh.pa.us>
	<1134629567.14248.27.camel@firebolt>
	<200512150148.16125.blargity@gmail.com>
	<1134644526.14248.60.camel@firebolt>
	<43A1C40D.8040006@paradise.net.nz>
	<43A1F6DB.3080805@modgraph-usa.com>
	<43A21D74.8030002@familyhealth.com.au>
	<c2d9e70e0512151800l5561fc04q7ee79593dcb4ea5c@mail.gmail.com>
	<43A2203B.2050102@familyhealth.com.au>
	<43A2251A.60907@modgraph-usa.com>
	<43A227BE.9030106@familyhealth.com.au>

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't been resolved.

Craig



view thread (41+ messages)  latest in thread

Message-ID: <43A23079.8060307@modgraph-usa.com>
Permalink:  ../43A23079.8060307@modgraph-usa.com/
Also on:    postgresql.org/message-id/43A23079.8060307@modgraph-usa.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: cjames@modgraph-usa.com
  Subject: Re: Overriding the optimizer
  In-Reply-To: <43A23079.8060307@modgraph-usa.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox