| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Matthew Sackman <matthew(at)lshift(dot)net> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Massive performance issues |
| Date: | 2005-09-01 22:34:36 |
| Message-ID: | 20050901223436.GA44175@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Sep 01, 2005 at 06:42:31PM +0100, Matthew Sackman wrote:
>
> "address_pc_top_index" btree (postcode_top)
> "address_pc_top_middle_bottom_index" btree (postcode_top,
> postcode_middle, postcode_bottom)
> "address_pc_top_middle_index" btree (postcode_top, postcode_middle)
This doesn't address the query performance problem, but isn't only
one of these indexes necessary? The second one, on all three
columns, because searches involving only postcode_top or only
postcode_top and postcode_middle could use it, making the indexes
on only those columns superfluous. Or am I missing something?
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Harris | 2005-09-01 23:02:49 | Re: Poor performance on HP Package Cluster |
| Previous Message | Matthew Sackman | 2005-09-01 22:22:39 | Re: Massive performance issues |