Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 05DAD2E3835 for ; Thu, 20 Dec 2007 06:05:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 38805-08 for ; Thu, 20 Dec 2007 06:05:23 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id A5FA22E385D for ; Thu, 20 Dec 2007 06:05:22 -0400 (AST) Received: by py-out-1112.google.com with SMTP id u77so7260356pyb.15 for ; Thu, 20 Dec 2007 02:05:20 -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:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=YrFZ0244mdFS+t/uKHN1i4qr6l6cvKS/1tmxXPpyob0=; b=fzNPr8mtpUPLiDsHYF4QffOjfBmRBTguEYFOM+Jpw09vovYupcKGOOqDZB5B01004w5TRHVeBCxztS1nGDBDWv2IAn/DCFTvQ1NBzl4fDA+gUFAL3665sve19GvMRHZTzZioWFeFNkmzzcWBcm0YklF6sDlU2jJ71KzcSAnWv8A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=FZI8U3nDWM4L7IsjP2bkLiIZ5532Xza5pR8kpv4ENC527he1ik5Ni23a2IDCvDsB0ou7gHbvxnErC8X8ehHS2YaXONe+jr4m/aNhzwH7qQSsYudQfi3n0JxcjYtEtp/oZkLAwgl1fGk0jjep6bdwEkpUUrIo5z3S1Yj2R5XkzQ8= Received: by 10.142.171.6 with SMTP id t6mr3434688wfe.126.1198145120279; Thu, 20 Dec 2007 02:05:20 -0800 (PST) Received: by 10.143.3.18 with HTTP; Thu, 20 Dec 2007 02:05:20 -0800 (PST) Message-ID: <92d3a4950712200205j3bb24e8ct1bb18a306a9ae9f8@mail.gmail.com> Date: Thu, 20 Dec 2007 11:05:20 +0100 From: "Anton Melser" To: pgsql-performance@postgresql.org Subject: Reinitialising stats once only without restarting MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/302 X-Sequence-Number: 28118 Hi, Sorry but I couldn't find the answer to this... I would like to empty all stats (pg_stat_all_tables probably mostly) so I can get an idea of what's going on now. Is this possible? I didn't want to just go deleting without knowing what it would do... Thanks Anton -- echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc This will help you for 99.9% of your problems ...