Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gunnar.bluth@pro-open.de>) id 1TVpb1-00047o-K0
	for pgsql-performance@postgresql.org; Tue, 06 Nov 2012 20:18:03 +0000
Received: from pro-open.de ([87.106.136.39] helo=www.pro-open.de)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gunnar.bluth@pro-open.de>) id 1TVpay-0000Ov-Ja
	for pgsql-performance@postgresql.org; Tue, 06 Nov 2012 20:18:03 +0000
Received: from [192.168.1.9] (ip-176-198-223-42.unitymediagroup.de
	[176.198.223.42])
	by www.pro-open.de (Postfix) with ESMTP id B9AFE100A0A8;
	Tue,  6 Nov 2012 21:17:59 +0100 (CET)
Message-ID: <50997077.1020500@pro-open.de>
Date: Tue, 06 Nov 2012 21:17:59 +0100
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:16.0) Gecko/20121028 Thunderbird/16.0.2
MIME-Version: 1.0
To: Petr Praus <petr@praus.net>
CC: Marcos Ortiz <mlortiz@uci.cu>, pgsql-performance@postgresql.org,
	klaussfreire@gmail.com, jeff.janes@gmail.com
Subject: Re: Re: Increasing work_mem and shared_buffers on Postgres
	9.2 significantly slows down queries
References: 
 <CACezXZ_w7HbqSxZ=5SJH=kxb4nBDNbpDejttSaU6EC1AeO4PYg@mail.gmail.com>
	<CACezXZ_UYbzvNEP_V6-bsyzGij-kJdeNz04-o=kbMXmcLMHnqw@mail.gmail.com>
	<5092DE42.5060206@uci.cu> <509304DC.1090809@pro-open.de>
	<CACezXZ-p1UK0K4EJH8b+EBuiD5HY0vNaQvxrnMcjwvjf9cb+oQ@mail.gmail.com>
	<5094F280.6010606@pro-open.de>
	<CACezXZ9SV58CbFM3-MpKGm1z-J0Ho1zERMUBuLH6QhC7RJ5T8Q@mail.gmail.com>
	<50954FAF.3060905@pro-open.de>
	<CACezXZ-NBmEd-Ur8TKvi2fhJkLAC=7w4y93ZPPzoFa1rZH+nmg@mail.gmail.com>
	<50962BCB.7020709@pro-open.de>
	<CACezXZ96RGOOR=vzCOA+Zv-froXSMr9QmJQCJRp_9ndtkszbzQ@mail.gmail.com>
	<50996746.5010508@pro-open.de>
	<CACezXZ8Tp90V+ahNbkZPZtiSFDZpWnQ+6WoBxoPMXAKbMn+GEQ@mail.gmail.com>
In-Reply-To: 
 <CACezXZ8Tp90V+ahNbkZPZtiSFDZpWnQ+6WoBxoPMXAKbMn+GEQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.3 (--)
X-Archive-Number: 201211/72
X-Sequence-Number: 48438

Am 06.11.2012 21:08, schrieb Petr Praus:
>
> 2MB: http://explain.depesz.com/s/ul1
> 4MB: http://explain.depesz.com/s/IlVu
> 10MB: http://explain.depesz.com/s/afx3
> 12MB: http://explain.depesz.com/s/i0vQ
>
See the change in the plan between 10MB and 12MB, directly at top level? 
That narrows the thing down quite a bit.

Though I wonder why this didn't show in the original plans...

-- 
Gunnar "Nick" Bluth
RHCE/SCLA

Mobil   +49 172 8853339
Email: gunnar.bluth@pro-open.de
__________________________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX.  Ten years later
they are choosing Windows over UNIX.  What part of that message aren't you
getting? - Tom Payne