Il 20/08/11 04:28, Tom Lane ha scritto:
Edoardo Panfili 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
Edoardo Panfili 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
On Fri, Aug 19, 2011 at 2:37 PM, Edoardo Panfili wrote:
>
> work_mem = 1MB
> random_page_cost = 4
>
> I am using an SSD but the production system uses a standard hard disk.
>
> I did a try also with
> set default_statistics_target=1;
> vacuum analyze cartellino;
> vacuum analyze specie; -- t
Il 19/08/11 22:15, Scott Marlowe ha scritto:
On Fri, Aug 19, 2011 at 1:05 PM, Edoardo Panfili wrote:
[1] Plan for the firts query
---
Sort (cost
On Fri, Aug 19, 2011 at 1:05 PM, Edoardo Panfili wrote:
> [1] Plan for the firts query
> ---
> Sort (cost=20.45..20.46 rows=1 width=931) (actual tim
