From: Dave Dutcher <dave@tridecap.com>
To: 'Brian Herlihy' <btherl@yahoo.com.au>
To: pgsql-performance@postgresql.org
Subject: Re: Query planner is using wrong index.
Date: Thu, 6 Apr 2006 19:09:33 -0500
Message-ID: <00c101c659d7$8cc26a70$8300a8c0@tridecap.com> (raw)
In-Reply-To: <20060406235622.27528.qmail@web52307.mail.yahoo.com>
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Brian Herlihy
> Sent: Thursday, April 06, 2006 6:56 PM
> To: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Query planner is using wrong index.
[Snip]
> I am really surprised that I have to go through such contortions just
to
> use
> the primary key! This area of Postgres needs improvement.
>
Of course you mentioned that you are using 7.4.7. You might want to try
upgrading to 8.1.3. There have been a lot of improvements to the
performance since 7.4. I don't know if your specific problem was fixed,
but it's worth a try.
Also you might want to at least upgrade to 7.4.12 for the bug fixes.
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: dave@tridecap.com, btherl@yahoo.com.au
Subject: Re: Query planner is using wrong index.
In-Reply-To: <00c101c659d7$8cc26a70$8300a8c0@tridecap.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