pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL and Linux 2.6 kernel.
Date: Wed, 14 Apr 2004 21:12:18 +0100
Message-ID: <KGEFLMPJFBNNLNOOOPLGIEOBCHAA.simon@2ndquadrant.com> (raw)
In-Reply-To: <200404050836.52115.josh@agliodbs.com>

> Josh Berkus wrote:
> Unfortunately, these days only Tom and Neil seem to be
> seriously working on
> the query planner (beg pardon in advance if I've missed
> someone) so I think
> the real answer is that we need another person interested in
> this kind of
> optimization before it's going to get much better.
>

Hmmmm. Interesting line of thought.

Is the problem "a person interested" or is there another issue there?

I was thinking the other day that maybe removing the ability to control
join order through explicitly manipulating the FROM clause might
actually be counter productive, in terms of longer term improvement of
the optimizer.

Treating the optimizer as a black box is something I'm very used to from
other RDBMS. My question is, how can you explicitly re-write a query now
to "improve" it? If there's no way of manipulating queries without
actually re-writing the optimizer, we're now in a position where we
aren't able to diagnose when the optimizer isn't working effectively.

For my mind, all the people on this list are potential "optimizer
developers" in the sense that we can all look at queries and see whether
there is a problem with particular join plans. Providing good cases of
poor optimization is just what's needed to assist those few that do
understand the internals to continue improving things.

I guess what I'm saying is it's not how many people you've got working
on the optimizer, its how many accurate field reports of less-than
perfect optimization reach them. In that case, PostgreSQL is likely in a
better position than Microsoft, since the accessibility of the pg
discussion lists makes such cases much more likely to get aired.

Any thoughts?

Best Regards, Simon Riggs




view thread (34+ messages)  latest in thread

Message-ID: <KGEFLMPJFBNNLNOOOPLGIEOBCHAA.simon@2ndquadrant.com>
Permalink:  ../KGEFLMPJFBNNLNOOOPLGIEOBCHAA.simon@2ndquadrant.com/
Also on:    postgresql.org/message-id/KGEFLMPJFBNNLNOOOPLGIEOBCHAA.simon@2ndquadrant.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: simon@2ndquadrant.com, josh@agliodbs.com
  Subject: Re: PostgreSQL and Linux 2.6 kernel.
  In-Reply-To: <KGEFLMPJFBNNLNOOOPLGIEOBCHAA.simon@2ndquadrant.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