Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 950B72E2FA4 for ; Thu, 20 Dec 2007 12:23:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 60271-06-2 for ; Thu, 20 Dec 2007 12:23:38 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.237]) by postgresql.org (Postfix) with ESMTP id 990AC2E0391 for ; Thu, 20 Dec 2007 12:23:38 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 58so2724931wri.10 for ; Thu, 20 Dec 2007 08:23:37 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=p/492rqWuSyc1FCRn2LSsXKQUIFlAxWfTe/nrMBRiiY=; b=Nq0nFQ89O2brSISss+HslMjZwF6XdOYQcMjHDhCTn+BzC+k1S/g7Vy/RAFMZPDasgPMeCglqXzXVkinCodDq8y7ZmeDQE2dItljAWGLR5ov5yOMHKvlp7tdnuPvYn8HOoHoZ282yqcsQHKbwgBT4NR2fmqp7Be7f+YSnLlOWCVk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AmdtNngziJDDIDtNp0yc6cMb3UJpKF6AdhJVhgaVmRCYfam1UeUF3r4LIPspLXIc01BfbDF7X1EGnw7QOEzRgq8FycuIcumFASI6zcXxi+nae5hZV69iz31uOQN2Vz2hsCDPGubCBvdh5lYZTbetRsuYl8I5J1JTp35wyHybgu4= Received: by 10.142.191.2 with SMTP id o2mr113009wff.209.1198167816707; Thu, 20 Dec 2007 08:23:36 -0800 (PST) Received: by 10.143.3.18 with HTTP; Thu, 20 Dec 2007 08:23:36 -0800 (PST) Message-ID: <92d3a4950712200823o13857dc3t60940c01d6198ae8@mail.gmail.com> Date: Thu, 20 Dec 2007 17:23:36 +0100 From: "Anton Melser" To: "Alvaro Herrera" Subject: Re: Reinitialising stats once only without restarting Cc: pgsql-performance@postgresql.org In-Reply-To: <20071220133559.GF5309@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <92d3a4950712200205j3bb24e8ct1bb18a306a9ae9f8@mail.gmail.com> <20071220133559.GF5309@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/308 X-Sequence-Number: 28124 On 20/12/2007, Alvaro Herrera wrote: > Anton Melser escribi=F3: > > 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... > > Sure, use pg_stat_reset(); Pura vida, gracias. A