X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7A170D70F6 for ; Mon, 17 Oct 2005 11:12:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03558-02 for ; Mon, 17 Oct 2005 14:12:00 +0000 (GMT) Received: from mx1.surnet.cl (mx2.surnet.cl [216.155.73.181]) by svr1.postgresql.org (Postfix) with ESMTP id B0C33D70CF for ; Mon, 17 Oct 2005 11:12:02 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 17 Oct 2005 11:11:32 -0300 Received: from alvh.no-ip.org (200.85.219.78) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 435015970003B015; Mon, 17 Oct 2005 11:12:06 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id CC518C2D469; Mon, 17 Oct 2005 11:12:13 -0300 (CLST) Date: Mon, 17 Oct 2005 11:12:13 -0300 From: Alvaro Herrera To: Rajesh Kumar Mallah Cc: pgsql-admin@postgresql.org Subject: Re: possibly outdated info in pg_stat_activity Message-ID: <20051017141213.GC18832@surnet.cl> Mail-Followup-To: Rajesh Kumar Mallah , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.037 required=5 tests=[AWL=-0.789, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, FORGED_RCVD_HELO=0.05, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200510/189 X-Sequence-Number: 19261 Rajesh Kumar Mallah wrote: > PID 3533 does not exists in the system but its still in pg_stat_activity. > This is PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc > (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-49). This is normal behavior. Sometimes the packets used to update the stat collector's information are lost due to the nature of the UDP socket. You shouldn't see this problem under light load. -- Alvaro Herrera Architect, http://www.EnterpriseDB.com "The first of April is the day we remember what we are the other 364 days of the year" (Mark Twain)