Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c5EBP-000283-4N for pgsql-performance@arkaria.postgresql.org; Fri, 11 Nov 2016 15:56:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c5EBN-0004DE-F2 for pgsql-performance@arkaria.postgresql.org; Fri, 11 Nov 2016 15:56:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c5EBM-0004Cp-Ka for pgsql-performance@postgresql.org; Fri, 11 Nov 2016 15:56:00 +0000 Received: from ns5.gunduz.org ([107.170.136.15] helo=ns1.gunduz.org) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c5EBJ-0006lK-AC for pgsql-performance@postgresql.org; Fri, 11 Nov 2016 15:56:00 +0000 Received: from asus-laptop-03-gunduz-org (unknown [88.248.122.226]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ns1.gunduz.org (Postfix) with ESMTPSA id 6BAD93FD9F; Fri, 11 Nov 2016 15:55:54 +0000 (UTC) Message-ID: <1478879749.25953.72.camel@gunduz.org> Subject: Re: Any advice tuning this query ? From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= To: henrik@ekenberg.pw, pgsql-performance Date: Fri, 11 Nov 2016 18:55:49 +0300 In-Reply-To: <20161111161908.Horde.cKoJtI5NzvW4R1L4Y2MGJct@box1242.bluehost.com> References: <20161111161908.Horde.cKoJtI5NzvW4R1L4Y2MGJct@box1242.bluehost.com> Content-Type: multipart/signed; micalg="pgp-sha256"; protocol="application/pgp-signature"; boundary="=-f5dMfAUy70veT4ir6ohg" X-Mailer: Evolution 3.20.5 (3.20.5-1.fc24) Mime-Version: 1.0 X-Pg-Spam-Score: -4.8 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --=-f5dMfAUy70veT4ir6ohg Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, On Fri, 2016-11-11 at 16:19 +0100, Henrik Ekenberg wrote: > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Sort Method: external me= rge=C2=A0 Disk: 16782928kB This query is generating 16GB temp file on disk. Is this the amount of data= you want to sort? Regards, --=20 Devrim G=C3=9CND=C3=9CZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR --=-f5dMfAUy70veT4ir6ohg Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAABCAAGBQJYJeoFAAoJENjDPf6Sz261P7QP/REnc4cZHcYa8GsNaZm6U8Od MrTV5sgoc3h4t+3gAjhPQ/ecdGY+9JMFroj2nndpAe+3f21hMzo5QnodrAkrrpRX CaeF5AZF8uNE66DyyRAcZzzJqARgu8CqlZFz9NIAtNXOM21p0rNCmJCileV+Eugo XgJhuP2DT78HuDf7D5dp7Kh6wE6ZAzMvAzH4X1n95dwjIlNN3CDdqwbRmZcNuIqS 1ufxt7OFtJZfhklkKgKKGeV4oxgv0Tu3U4jvAj98hfv+dddi6Rs2RNHxIsvYmZGi DYfcEX18W+fBWXuYiB/wytGsYXoJioUzLQWT22Dd8EDaIKgKsMvD2Hst3KB0STE1 BZ5vJJhHhWJErCm18o2J24Tgm4SlQzWE/fVB5eyAR9j8JRz0cn/3KTLb5zqDw/P/ Q9XNsXfVl6SvdO6GSt6/EEG49MMEShG4WDkg0VUX+mIrBeQRsfrvTAIUMI1j7Jcy ORhm8ZW0PBaKEgOhtjG6nwy8geLzodzGHN2Guuk6Ce94hjACcXkyVmheao+ILCCr 4Tfs57bVJmrYe6e9gfHVeVgS8ZEioNdcHkFhFmEODzraq/lztcnQn96R6fD9bglS 0/yJC6/TA9wgnp8LpsX/36iNyWupazPf5VRYkJu5U9GicKU6dJiyFQWA3r64iY9x JbFUWrROzWvRoiLfcsF5 =POVH -----END PGP SIGNATURE----- --=-f5dMfAUy70veT4ir6ohg--