Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z5xZg-0003p0-2e for pgsql-performance@arkaria.postgresql.org; Fri, 19 Jun 2015 14:47:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z5xZf-00082x-HK for pgsql-performance@arkaria.postgresql.org; Fri, 19 Jun 2015 14:47:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z5xZb-0007wb-3g for pgsql-performance@postgresql.org; Fri, 19 Jun 2015 14:47:15 +0000 Received: from mailout01.ims-firmen.de ([213.174.32.96]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Z5xZX-0007vC-Hk for pgsql-performance@postgresql.org; Fri, 19 Jun 2015 14:47:14 +0000 Received: from mailin01.ims-firmen.de ([192.168.1.141]) by mailout01.ims-firmen.de with esmtp (envelope-from ) id 1Z5xZV-000683-i0; Fri, 19 Jun 2015 16:47:09 +0200 Received: from [213.174.32.192] (helo=oxweb02.ims-firmen.de) by mailin01.ims-firmen.de with esmtpsa (TLSv1:RC4-MD5:128) (envelope-from ) id 1Z5xZV-0005Kh-1u; Fri, 19 Jun 2015 16:47:09 +0200 Date: Fri, 19 Jun 2015 16:47:09 +0200 (CEST) From: Andreas Kretschmer Reply-To: Andreas Kretschmer To: Ian Pushee , pgsql-performance@postgresql.org Message-ID: <1405767375.375868.1434725229563.JavaMail.open-xchange@oxweb02.ims-firmen.de> In-Reply-To: <55842859.4060102@intuvisiontech.com> References: <55842859.4060102@intuvisiontech.com> Subject: Re: Slow query (planner insisting on using 'external merge' sort type) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Medium X-Mailer: Open-Xchange Mailer v7.6.2-Rev12 X-Originating-Client: com.openexchange.ox.gui.dhtml X-Pg-Spam-Score: -2.6 (--) 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 > Explain Analyze outputs (links as requested): > Default plan: http://explain.depesz.com/s/ib3k > Forced index (random_page_cost=1.0): http://explain.depesz.com/s/lYaP > > Software/Hardware: PGSql 9.2.1, Windows 8.1, 8GB RAM > All pgsql settings are at their defaults. increase work_mem. per session via set work_mem = 'xxxMB'; or in postgresql.conf, reload. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance