pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Filip Rembiałkowski <filip.rembialkowski@gmail.com>
To: Andreas Kretschmer <akretschmer@spamfence.net>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: query slowdown after 9.0 -> 9.4 migration
Date: Wed, 2 Nov 2016 18:43:02 -0500
Message-ID: <e2fc6b36-8da9-0447-9e3d-193993c2512a@BlueTreble.com> (raw)
In-Reply-To: <CAP_rwwmXxqASHJApuKQkfzEMfMv7xWDsBnOY5Ybe1i6J9qreRg@mail.gmail.com>
References: <CAP_rwwn6AqwfCDsmpzVaoZd_6FSu7RFECqqfUPGf2n9uv+VVuA@mail.gmail.com>
	<c933c63e-4050-49ef-566c-0b40de1f46dd@2ndquadrant.com>
	<20161027053838.GA5952@tux>
	<CAP_rwwmXxqASHJApuKQkfzEMfMv7xWDsBnOY5Ybe1i6J9qreRg@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (5+ messages)

Message-ID: <e2fc6b36-8da9-0447-9e3d-193993c2512a@BlueTreble.com>
Permalink:  ../e2fc6b36-8da9-0447-9e3d-193993c2512a@BlueTreble.com/
Also on:    postgresql.org/message-id/e2fc6b36-8da9-0447-9e3d-193993c2512a@BlueTreble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: Jim.Nasby@BlueTreble.com, filip.rembialkowski@gmail.com, akretschmer@spamfence.net
  Subject: Re: query slowdown after 9.0 -> 9.4 migration
  In-Reply-To: <e2fc6b36-8da9-0447-9e3d-193993c2512a@BlueTreble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox