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

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dave Dutcher <dave@tridecap.com>
Cc: 'Chris' <dmagick@gmail.com>
Cc: 'i.v.r.' <ivanvega@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help understanding indexes, explain, and optimizing
Date: Tue, 07 Mar 2006 10:34:57 -0500
Message-ID: <18785.1141745697@sss.pgh.pa.us> (raw)
In-Reply-To: <003b01c641f8$39185a70$8300a8c0@tridecap.com>
References: <003b01c641f8$39185a70$8300a8c0@tridecap.com>

"Dave Dutcher" <dave@tridecap.com> writes:
> It sounds like the original posters problem was a less than optimal join
> order, and from what I understand Postgres can't reorder left joins.  

Not really relevant to the OP's immediate problem, but: that's fixed in
CVS HEAD.

http://archives.postgresql.org/pgsql-hackers/2005-12/msg00760.php
http://archives.postgresql.org/pgsql-committers/2005-12/msg00352.php

			regards, tom lane

view thread (5+ messages)

Message-ID: <18785.1141745697@sss.pgh.pa.us>
Permalink:  ../18785.1141745697@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/18785.1141745697@sss.pgh.pa.us

copy link · copy postgr.es

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: tgl@sss.pgh.pa.us, dave@tridecap.com, dmagick@gmail.com, ivanvega@gmail.com
  Subject: Re: Help understanding indexes, explain, and optimizing
  In-Reply-To: <18785.1141745697@sss.pgh.pa.us>

* 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