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

Started by hmidi slimover 8 years ago1 messagesgeneral
Jump to latest
#1hmidi slim
hmidi.slim2@gmail.com

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?

Attachments:

12.PNGimage/png; name=12.PNGDownload
14.PNGimage/png; name=14.PNGDownload
13.PNGimage/png; name=13.PNGDownload
11.pngimage/png; name=11.pngDownload