Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5ABD62E3D37 for ; Thu, 29 Nov 2007 17:58:42 -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 58927-01-9 for ; Thu, 29 Nov 2007 17:58:33 -0400 (AST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by postgresql.org (Postfix) with ESMTP id 752892E3CCC for ; Thu, 29 Nov 2007 17:54:20 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id f5so1686426nfh for ; Thu, 29 Nov 2007 13:54:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; bh=LIaz5kzAuX782C/ADL5t3J7yHg2IuaV0q+4oOjafkw0=; b=I9Gwpl8yMBY5nH8EldtnX2L26SVr3FDHuLtXa4TnLp3f0UM1Eidl04meXlsd30C/R6C35NtuLvosUJ9Wg8QSu+KyEhviIugSE+ZUIqVs87Uv4ycqDBgXRDNb8iRISZAbkJ0++ycgMWg7w0t9aV6hgiEY97rT57lbLYgt4t3br1o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=t7QRKvjZzY+K9hkZtEZgvrfmU/GUW3RHUKSL0X+c17H8zJxV/8R7nuXB9y/vpCZbP43x5dXyWkc/Sdm92SmFqQS1GZRCzRIGaehBoowbcFlQktlgMDJSObPYJda9KJQ0IdHYjDIFIp+TP4GvM5pihOxkjj/ZCnv2sZXF/7MqQmw= Received: by 10.78.183.15 with SMTP id g15mr7636255huf.1196373255459; Thu, 29 Nov 2007 13:54:15 -0800 (PST) Received: from ?172.24.32.184? ( [62.232.55.118]) by mx.google.com with ESMTPS id 6sm760247nfv.2007.11.29.13.54.12 (version=SSLv3 cipher=RC4-MD5); Thu, 29 Nov 2007 13:54:14 -0800 (PST) Message-ID: <474F3500.7010109@enterprisedb.com> Date: Thu, 29 Nov 2007 21:54:08 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.14pre (X11/20071020) MIME-Version: 1.0 To: "Campbell, Lance" CC: pgsql-performance@postgresql.org Subject: Re: clear pg_stats References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/387 X-Sequence-Number: 27802 Campbell, Lance wrote: > How can I clear the pg_stats views without restarting PostgreSQL? I > thought there was a function. SELECT pg_stat_reset(); -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com