From: Devrim Gündüz <devrim@gunduz.org>
To: henrik@ekenberg.pw, pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Any advice tuning this query ?
Date: Fri, 11 Nov 2016 18:55:49 +0300
Message-ID: <1478879749.25953.72.camel@gunduz.org> (raw)
In-Reply-To: <20161111161908.Horde.cKoJtI5NzvW4R1L4Y2MGJct@box1242.bluehost.com>
References: <20161111161908.Horde.cKoJtI5NzvW4R1L4Y2MGJct@box1242.bluehost.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi,
On Fri, 2016-11-11 at 16:19 +0100, Henrik Ekenberg wrote:
> Sort Method: external merge Disk: 16782928kB
This query is generating 16GB temp file on disk. Is this the amount of data you
want to sort?
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachments:
signature.asc (application/pgp-signature, 818B) download
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: devrim@gunduz.org
Subject: Re: Any advice tuning this query ?
In-Reply-To: <1478879749.25953.72.camel@gunduz.org>
* 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