Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id C5BCDF6332B
	for <pgsql-performance@postgresql.org>;
	Thu, 19 Jul 2012 12:13:57 -0300 (ADT)
Received: from plane.gmane.org ([80.91.229.3])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gcdpp-pgsql-performance@m.gmane.org>)
	id 1SrsQ8-0005pc-Fs
	for pgsql-performance@postgresql.org; Thu, 19 Jul 2012 15:13:56 +0000
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <gcdpp-pgsql-performance@m.gmane.org>)
	id 1SrsPv-0006Mu-0m
	for pgsql-performance@postgresql.org; Thu, 19 Jul 2012 17:13:27 +0200
Received: from 212.255.19.188 ([212.255.19.188])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Thu, 19 Jul 2012 17:13:27 +0200
Received: from mandavi by 212.255.19.188 with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Thu, 19 Jul 2012 17:13:27 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-performance@postgresql.org
From: Felix Scheicher <mandavi@web.de>
Subject: Re: queries are fast after dump->restore but slow again after some
	days dispite vacuum
Date: Thu, 19 Jul 2012 15:13:14 +0000 (UTC)
Lines: 12
Message-ID: <loom.20120719T160306-28@post.gmane.org>
References: <loom.20120719T133136-384@post.gmane.org>
	<5007FFDD.5050103@dunslane.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: sea.gmane.org
User-Agent: Loom/3.14 (http://gmane.org/)
X-Loom-IP: 212.255.19.188 (Mozilla/5.0 (X11;
	Linux x86_64) AppleWebKit/536.11 (KHTML, like Gecko)
	Chrome/20.0.1132.57 Safari/536.11)
X-Pg-Spam-Score: -0.7 (/)
X-Archive-Number: 201207/234
X-Sequence-Number: 47415

Andrew Dunstan <andrew <at> dunslane.net> writes:

> Try running CLUSTER on the relevant tables and see if it makes a 
> difference. If it does you might want to look into using pg_reorg 
> periodically.


That worked like a charm! Many thanks. But how comes, the queries are also fast 
after a restore without the cluster?

regards,
Felix