| From: | "Dave Dutcher" <dave(at)tridecap(dot)com> |
|---|---|
| To: | "'Brian Herlihy'" <btherl(at)yahoo(dot)com(dot)au>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Query planner is using wrong index. |
| Date: | 2006-04-07 00:09:33 |
| Message-ID: | 00c101c659d7$8cc26a70$8300a8c0@tridecap.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-
> owner(at)postgresql(dot)org] On Behalf Of Brian Herlihy
> Sent: Thursday, April 06, 2006 6:56 PM
> To: pgsql-performance(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Herlihy | 2006-04-07 00:15:38 | Re: Query planner is using wrong index. |
| Previous Message | Brian Herlihy | 2006-04-06 23:56:21 | Re: Query planner is using wrong index. |