Re: query slowdown after 9.0 -> 9.4 migration - Mailing list pgsql-performance

From Jim Nasby
Subject Re: query slowdown after 9.0 -> 9.4 migration
Date
Msg-id e2fc6b36-8da9-0447-9e3d-193993c2512a@BlueTreble.com
Whole thread Raw
In response to Re: query slowdown after 9.0 -> 9.4 migration  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
List pgsql-performance
On 10/27/16 8:37 PM, Filip Rembiałkowski wrote:
> Does it make sense to ask on postgis-users list?

Yes. I suspect that the reason Buffers: shared hit is so high is because
of something st_distance_sphere() is doing.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: limit 1 on view never finishes
Next
From: Jim Nasby
Date:
Subject: Re: Big Memory Boxes and pgtune