Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 25E2B9FB2DA for ; Tue, 27 Mar 2007 07:36:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 86507-10 for ; Tue, 27 Mar 2007 07:36:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from designaproduct.biz (135-shost.hostoffice.hu [195.228.74.135]) by postgresql.org (Postfix) with ESMTP id 7EE099FB28C for ; Tue, 27 Mar 2007 07:36:30 -0300 (ADT) Received: from [172.16.0.43] (localhost [127.0.0.1]) by designaproduct.biz (Postfix) with ESMTP id 200DB1DD41C; Tue, 27 Mar 2007 06:29:04 -0400 (EDT) Message-ID: <4608F3AE.8070002@designaproduct.biz> Date: Tue, 27 Mar 2007 12:36:30 +0200 From: Laszlo Nagy User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Jim Nasby , pgsql-admin@postgresql.org Subject: Re: autovacuum question References: <46080037.9020209@designaproduct.biz> <3DD60E78-DAB8-49F6-A939-5C7C0E19C582@decibel.org> In-Reply-To: <3DD60E78-DAB8-49F6-A939-5C7C0E19C582@decibel.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/209 X-Sequence-Number: 25033 Jim Nasby írta: > Autovacuum doesn't launch a separate daemon; you'll only see an > autovac process when an autovac is actually working. Where should I see it? The output of "ps ax | grep auto" is empty. Does it mean that auto vacuum is not running? How can I check if there is a problem? > > Also, 8.1 has code to prevent wraparound, so that's not it (see > backend/access/transam/varsup.c) Oh, then do you have any idea what caused this? E.g. a postgres client seeing an older version of the data? "Older" means that the postgres client was started today and it saw the data from 2 days ago, then suddenly it started to see the fresh data. Thanks, Laszlo