Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 73BFA2E3F0A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 29 Nov 2007 18:00:53 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 59643-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 29 Nov 2007 18:00:46 -0400 (AST)
Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226])
	by postgresql.org (Postfix) with ESMTP id 4FBE72E3FE0
	for <pgsql-performance@postgresql.org>;
	Thu, 29 Nov 2007 17:56:52 -0400 (AST)
Received: from dynamic.hagander.net ([127.0.0.1]) (encrypted and
	authenticated) by svr2.hagander.net (Postfix) with ESMTP id
	3C20CDCCC47; Thu, 29 Nov 2007 22:56:51 +0100 (CET)
Message-ID: <474F35C5.9080103@hagander.net>
Date: Thu, 29 Nov 2007 22:57:25 +0100
From: Magnus Hagander <magnus@hagander.net>
User-Agent: Thunderbird 2.0.0.9 (X11/20071031)
MIME-Version: 1.0
To: "Campbell, Lance" <lance@uiuc.edu>
CC: pgsql-performance@postgresql.org
Subject: Re: clear pg_stats
References: <B10E6810AC2A2F4EA7550D072CDE8760197E2B@SAB-FENWICK.sab.uiuc.edu>
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760197E2B@SAB-FENWICK.sab.uiuc.edu>
X-Enigmail-Version: 0.95.5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/388
X-Sequence-Number: 27803

Campbell, Lance wrote:
> How can I clear the pg_stats views without restarting PostgreSQL?  I
> thought there was a function.

pg_stat_reset()

//Magnus