Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 820A72E0072 for ; Mon, 16 Jun 2008 23:33:03 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11016-06 for ; Mon, 16 Jun 2008 23:32:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by developer.postgresql.org (Postfix) with ESMTP id AE8E72E005E for ; Mon, 16 Jun 2008 23:32:59 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n4so4435640wag.5 for ; Mon, 16 Jun 2008 19:32:58 -0700 (PDT) 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=TaPXm/HUawgTDl6Eu+z7gMP7M8/Cp20TAriWVNp4yA8=; b=pWGcPhoMlGs2xFIrXWFv8Y+1is8dgJCi0vkk7T05hLXjh/xIHLf+C3q5qttc2rPbl/ sdt0DyEuUsVi6+ohbWhBBlxra4XL0ZtQ9kN3cfjNsdCu+v/XFXNP3b90zwJ8JyrcuORd ioGOCAn8vaRQlY0E68CEszYsLBiX2bVg0cpfQ= 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=sdKMRtdisrZqC497btL2tnT9Oy1J287Pd8CntbIq8UUTlUn5GjsoHgBwRIV/GNv7cc Df3c7AaYKuWE6h4GCmv98lNyL9d07bx7JlSA9xu8QUCMP1fqqYuVipJUU1JbBQv5ONp9 vIuxIpq5Qndrk96QXLxIM5WSNyD9FqtJJ6R7I= Received: by 10.114.157.1 with SMTP id f1mr7266519wae.14.1213669978242; Mon, 16 Jun 2008 19:32:58 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Mon, 16 Jun 2008 19:32:58 -0700 (PDT) Message-ID: Date: Mon, 16 Jun 2008 20:32:58 -0600 From: "Scott Marlowe" To: "Miracapillo Alessandro" Subject: Re: I: Purge Oid Cc: pgsql-admin@postgresql.org In-Reply-To: <1A29A61B8C7BAE419940B34E2E04F4C0032C760E@BESTWO.corp.dom> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1A29A61B8C7BAE419940B34E2E04F4C0032C760E@BESTWO.corp.dom> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/128 X-Sequence-Number: 29466 2008/6/13 Miracapillo Alessandro : > > > Hallo, > > > > I've a problem with postgress 8.1, > > > > Db_data FS is full because file oid are too large, how I can delete old OID > file without to risk to damage oid relation database Ummm, the data directory doesn't fill up because of high oids. is the data dir full, or are you suffering from oid wraparound issues? Two different things.