Re: query slowdown after 9.0 -> 9.4 migration

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>, Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: query slowdown after 9.0 -> 9.4 migration
Date: 2016-11-02 23:43:02
Message-ID: e2fc6b36-8da9-0447-9e3d-193993c2512a@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim Nasby 2016-11-02 23:46:47 Re: Big Memory Boxes and pgtune
Previous Message Jim Nasby 2016-11-02 23:37:03 Re: limit 1 on view never finishes