X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 466169DC800 for ; Fri, 10 Feb 2006 17:32:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12770-07 for ; Fri, 10 Feb 2006 17:32:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fusion.bennyvision.com (users.bennysworldofporn.com [71.32.179.124]) by postgresql.org (Postfix) with SMTP id A0BFF9DC855 for ; Fri, 10 Feb 2006 17:32:22 -0400 (AST) Received: (qmail 9668 invoked by uid 1007); 10 Feb 2006 21:32:24 -0000 Received: from localhost (HELO webmail.stinkweasel.net) (127.0.0.1) by fusion.bennyvision.com with SMTP; 10 Feb 2006 21:32:24 -0000 Received: from 134.244.169.17 (SquirrelMail authenticated user benny) by webmail.stinkweasel.net with HTTP; Fri, 10 Feb 2006 15:32:24 -0600 (CST) Message-ID: <4167.134.244.169.17.1139607144.squirrel@webmail.stinkweasel.net> In-Reply-To: <43ED0369.2090705@ca.afilias.info> References: <2894.134.244.169.17.1139587037.squirrel@webmail.stinkweasel.net> <6064nneznu.fsf@dba2.int.libertyrms.com> <4131.134.244.169.17.1139606011.squirrel@webmail.stinkweasel.net> <43ED0369.2090705@ca.afilias.info> Date: Fri, 10 Feb 2006 15:32:24 -0600 (CST) Subject: Re: Is the database being VACUUMed? From: "C. Bensend" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.5 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.06 required=5 tests=[AWL=0.060] X-Spam-Score: 0.06 X-Spam-Level: X-Archive-Number: 200602/117 X-Sequence-Number: 20538 > Well, you have to turn on the stats collector, so you will pay a little > bit of a performance penalty for that. I doubt you'll notice it unless > you're really close to the edge. You do have to restart the database to > enable the stats collector if it's off. The pg_stat_activity stuff is > pretty essential for debugging problems in the database. I already have the stats collector on, so that's OK. And my database is very simple, very much my own research project, so bouncing it is no problem. This looks like it will solve my problem nicely. Thanks to all of you! Benny -- "'And you've got 10 gig of files to put through our mail system?' I ask, squeezing my mouse in a non-approved manner." -- BOFH, 2006-01