Re: [postgis-users] Optimizer choosing slower strategy (Bitmap Heap vs Index)?

2017-07-26 Thread Dan Lyke
Lest it get lost further down: THANK YOU! This gives me some things to continue searching on: On Wed, 26 Jul 2017 12:31:07 +0200 Giuseppe Broccolo wrote: > On old dataset, the index is scanned through the bitmap: there are two > phases, in the first the index is used to build a bitmap, then the

Re: [postgis-users] Optimizer choosing slower strategy (Bitmap Heap vs Index)?

2017-07-26 Thread Giuseppe Broccolo
Hi Dan, 2017-07-25 18:47 GMT+02:00 Dan Lyke : > I'm trying to figure out a performance issue between two quarters of > map data. Both are using PosgreSQL 9.5.4 on Amazon RDS. The current > quarter's data appears to be much slower than the old quarter's data. > > VACUUM ANALYZE has been run. > > E