Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1TLAMw-00071m-AA
	for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 10:15:26 +0000
Received: from mail-pa0-f46.google.com ([209.85.220.46])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1TLAMt-0003pc-5n
	for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 10:15:24 +0000
Received: by mail-pa0-f46.google.com with SMTP id hz1so3815962pad.19
	for <pgsql-performance@postgresql.org>;
	Mon, 08 Oct 2012 03:15:20 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding
	:x-gm-message-state;
	bh=Zq95ngMIrJpDeljulEUbRQybIuvAiU/ZOFLKYGKiVM4=;
	b=InLCxAi0B2NAyqFlkedE1TRWvEr61voSDwY+Vch4KGpU30sN6K0VtZVo4pr6zDpXbm
	W3BMWlbxkNEuGLCY0FhXC3hPmK1EqhnCd4gWagQ/UI1ZUAZAq7Ocqf28Z4IM7BMasxKJ
	EJ2byEHrs5jwBj95hCRQo7Lmf3mufTe8gnHacXGCJIBnxA7DSQ/19XU0Vm6PJY9JOpT9
	TkcvWIdrs7GpHfNku3l1bfNh7XxjZ10dv15Mo/4bCsW7zJJ0OadFnSlwGlUhuGJLo9fU
	1E8WylTc1Cu+AWNPvUGyMowRB04sgmYpdyF4JonYZpGorh+GHOOWPHTxSlVGrxvbCvAH
	Q5og==
Received: by 10.68.222.226 with SMTP id qp2mr51337142pbc.57.1349691320860;
	Mon, 08 Oct 2012 03:15:20 -0700 (PDT)
Received: from ayaki.localdomain (125-238-84-125.jetstream.xtra.co.nz.
	[125.238.84.125])
	by mx.google.com with ESMTPS id gk5sm10516689pbc.21.2012.10.08.03.15.17
	(version=SSLv3 cipher=OTHER); Mon, 08 Oct 2012 03:15:19 -0700 (PDT)
Message-ID: <5072A7B3.8090001@ringerc.id.au>
Date: Mon, 08 Oct 2012 18:15:15 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:14.0) Gecko/20120717 Thunderbird/14.0
MIME-Version: 1.0
To: Andrzej Zawadzki <zawadaa@wp.pl>
CC: pgsql-performance@postgresql.org
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
References: <50728C3E.9050904@wp.pl>
In-Reply-To: <50728C3E.9050904@wp.pl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Gm-Message-State: 
 ALoCoQlpk5NaoF9z1MvW7WY5eHVn+Ei2DT0JrC1SiTcbE8jW1JnRR8W8TAwePUNg5x2/CCdZxfXl
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201210/40
X-Sequence-Number: 47999

On 10/08/2012 04:18 PM, Andrzej Zawadzki wrote:
> Hi!
>
> After upgrade (dump/restore/analyze) query (below) after some time is killed by kernel.

What's `shared_buffers`? `work_mem`?

https://wiki.postgresql.org/wiki/Server_Configuration

https://wiki.postgresql.org/wiki/Slow_Query_Questions

--
Craig Ringer