From: | Evgeny Gridasov <eugene(at)i-free(dot)ru> |
---|---|
To: | Dan Harris <fbsd(at)drivefaster(dot)net> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Help optimizing a slow index scan |
Date: | 2006-03-17 19:32:53 |
Message-ID: | 20060317223253.38c0e6b9.eugene@i-free.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Try contrib/btree_gist.
I've tried that one, but for my case it didn't help much.
The performance was almost equal or even slower than built-in btree.
On Fri, 17 Mar 2006 08:53:44 -0700
Dan Harris <fbsd(at)drivefaster(dot)net> wrote:
> Dan Harris wrote:
> > Markus Bertheau wrote:
> >> Have you tried using a GIST index on lat & long? These things are
> >> meant for two-dimensional data, whereas btree doesn't handle
> >> two-dimensional data that well. How many rows satisfy either of the
> >> long / lat condition?
> >>
> >>
> >>>
> > According to the analyze, less than 500 rows matched. I'll look into
> > GIST indexes, thanks for the feedback.
> >
> > -Dan
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>
> When I try to create a GIST index, I get the following error:
>
> create index eventgeo_lat_idx on eventgeo using GIST (lat);
>
> ERROR: data type double precision has no default operator class for
> access method "gist"
> HINT: You must specify an operator class for the index or define a
> default operator class for the data type.
>
> I'm not sure what a "default operator class" is, exactly..
>
> -Dan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
Evgeny Gridasov
Software Engineer
I-Free, Russia
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Harris | 2006-03-17 20:44:54 | Re: Help optimizing a slow index scan |
Previous Message | Evgeny Gridasov | 2006-03-17 18:36:06 | Re: Background writer configuration |