[postgis-users] Strange result about spatial indexes?

Paul Ramsey pramsey at opengeo.org
Fri Aug 14 10:51:51 PDT 2009


Incidentally, I don't think switching our storage type is the
solution, it is treating the symptom (time spent in gist consistent)
rather than the disease (so very many calls into gist consistent).

On Fri, Aug 14, 2009 at 10:18 AM, Paul Ramsey<pramsey at opengeo.org> wrote:
> Switching from storage = main (compression allowed) to storage =
> external (no compression please) in the create type declaration makes
> the standard query 5 times faster (489ms vs 2441ms), but still 5 times
> slower than the st_expanded case (96ms).
>
> Attached is the new shark profile.
>
> On Fri, Aug 14, 2009 at 10:06 AM, Paul Ramsey<pramsey at opengeo.org> wrote:
>> Ok... well the problem is pretty clear, see the Shark profile
>> attached. Now to figure the solution :)
>>
>> On Fri, Aug 14, 2009 at 9:58 AM, Paul Ramsey<pramsey at cleverelephant.ca> wrote:
>>> Got it, Safari didn't like it but FF did.
>>>
>>> On Fri, Aug 14, 2009 at 9:52 AM, Kevin Neufeld<kneufeld at refractions.net> wrote:
>>>> Paul Ramsey wrote:
>>>>>
>>>>> I am still waiting for a
>>>>> sample data set I can download, that link didn't work for me at all.
>>>>>
>>>>
>>>> The link works for me.  The website has a download link to the zip file.
>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>
>>>
>>
>



More information about the postgis-users mailing list