Why the creation of spatial indexes decrease the performance of a query?

From: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Why the creation of spatial indexes decrease the performance of a query?
Date: 2017-12-06 15:26:34
Message-ID: CAMsqVxumjVtB9+iMOLcFbsnuhnA+y-9zgOJLpV8SPo_qr0S=vA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I'm using postgresql 9.6.4 on linux and I'm trying to execute this query on
a table contains 51000 rows.

and I got this query plan:

​​
Creation of index:
​I get this queryPlan:

​Why the execution time increases when creating a spatial index on a table
containing a large amount of data?

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-12-06 18:53:22 Re: Does Postgresql 10 query partitions in parallel?
Previous Message Magnus Hagander 2017-12-06 15:00:21 Re: a back up question