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<[email protected]> 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<[email protected]> 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<[email protected]> >> wrote: >>> Got it, Safari didn't like it but FF did. >>> >>> On Fri, Aug 14, 2009 at 9:52 AM, Kevin Neufeld<[email protected]> >>> 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 >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>> >>> >> > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
