Re: A questions on planner choices - Mailing list pgsql-general

From Edoardo Panfili
Subject Re: A questions on planner choices
Date
Msg-id 4E4F5B1B.9080609@aspix.it
Whole thread Raw
In response to Re: A questions on planner choices  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Il 20/08/11 04:28, Tom Lane ha scritto:
> Edoardo Panfili<edoardo@aspix.it>  writes:
>> [ poor plan for a Postgis query with ]
>> Postgres 8.4.8 with postgis 1.5.3
>
> I think that most of the issue here is poor selectivity estimation for
> the Postgis operations, particularly&&.  I suggest that you should ask
> about this on the postgis mailing lists.  They might well tell you to
> try a newer release --- they may have improved things since 1.5.3.
1.5.3 is the latest stable release, I am downloading 2.0.0SVN


>> NOTICE:  LWGEOM_gist_joinsel called with incorrect join type
>
> You should *definitely* report that to the Postgis guys, because it's a
> bug.
I will do it

Thank you
Edoardo Panfili

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: A questions on planner choices
Next
From: DM
Date:
Subject: Re: MySQL -> PostgreSQL conversion issue