From: Brian Herlihy <btherl@yahoo.com.au>
To: pgsql-performance@postgresql.org
Subject: Re: Query planner is using wrong index.
Date: Fri, 7 Apr 2006 10:15:38 +1000 (EST)
Message-ID: <20060407001538.89517.qmail@web52308.mail.yahoo.com> (raw)
In-Reply-To: <00c101c659d7$8cc26a70$8300a8c0@tridecap.com>
--- Dave Dutcher <dave@tridecap.com> wrote:
> > -----Original Message-----
> > 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.
Thanks for the suggestions. I've verified the same problem in 8.1.3 as well,
after my initial post. It was actually in 8.1.3 that I first discovered the
problem.
I noticed this item in the TODO list:
- Allow accurate statistics to be collected on indexes with more than one
column or expression indexes, perhaps using per-index statistics
This is what I need! But until that is added, I need a way to use the primary
key with the current version :)
Thanks,
Brian
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: btherl@yahoo.com.au
Subject: Re: Query planner is using wrong index.
In-Reply-To: <20060407001538.89517.qmail@web52308.mail.yahoo.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