Re: Directly programmed query plans?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Josh ben Jore <jbenjore(at)whitepages(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Directly programmed query plans?
Date: 2006-12-22 03:25:27
Message-ID: 1A16351E-ACFD-428C-8289-206EBC812047@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Dec 20, 2006, at 17:34 , Josh ben Jore wrote:

> I vaguely recall that there’s an interface to PostgreSQL 7.3 where
> developers can directly feed it query plans. Can someone help me
> remember where this lived and whether it worked?
>
>
>
> The problem I’m looking at is that it’s difficult to impossible to
> get optimal uses of indexes all the time. Some of our queries are
> “optimized” particularly poorly. Perhaps, just perhaps it might be
> useful to be able to write a query using the compiled form rather
> than the SQL form. Any suggestions to help solve the real problem
> of index hinting would also be welcomed.
I don't know anything about a particular interface to 7.3, but if
you're still using 7.3 and are having problems with plans not being
properly optimized, I highly recommend upgrading to 8.2. There have
been substantial improvements to both the planner in particular and
performance in general in the last four releases.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message adam 2006-12-22 04:34:13 Best Perl DBI Driver for Postgres
Previous Message Ron Johnson 2006-12-22 03:07:49 Re: Partitioning Vs. Split Databases - performance?