Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 4FD022E0091 for ; Tue, 10 Jun 2008 12:52:45 -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 89618-02-9 for ; Tue, 10 Jun 2008 12:52:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by developer.postgresql.org (Postfix) with ESMTP id 1F81A2E0093 for ; Tue, 10 Jun 2008 12:52:30 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d37so1128261pye.29 for ; Tue, 10 Jun 2008 08:52:30 -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=bkhNpB2SY7aVvcPZypn66hlO+ykrq7iZv6I9tz0IYx8=; b=bN0TbdGiArroWaMRvjhF0v9ssvi9zsOryn9AR1t7fOKxhdXPsILWEHJzufuEtDbQll GzbvqJuv+FsKVnS7Q7H5slQHUEJZx9OGFZ2GHIIL1qRuJU1Aed73iGLtrU065rL2ZjI1 7zpxNNkN27POua8Kxx9G6uqRHMMVQtF99ztvk= 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=PTWiAXxilbmJZBFLWAY91uCZ52Oo0/ebZXPtz6l8deta+8Gp6AoBqCWQMMTJ1+Wvw0 ziOU+4ZxZ1c0O4KUmkZ3xLXl53zsswoqHhMKJsXXPY04Fmi75sG+1e76Rc/bJqLO2/5V Ne0RpZfns2bKE4VdPGQPSCjivK3koWh+yoYVA= Received: by 10.114.39.16 with SMTP id m16mr5118779wam.98.1213113149464; Tue, 10 Jun 2008 08:52:29 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Tue, 10 Jun 2008 08:52:29 -0700 (PDT) Message-ID: Date: Tue, 10 Jun 2008 09:52:29 -0600 From: "Scott Marlowe" To: alex Subject: Re: postgres 'forgets' table definitions Cc: pgsql-admin@postgresql.org In-Reply-To: <484E88AB.6020505@kerkhove.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <484E61A0.5030706@kerkhove.net> <484E88AB.6020505@kerkhove.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/74 X-Sequence-Number: 29412 On Tue, Jun 10, 2008 at 7:59 AM, alex wrote: > Problem solved! > > Even without vacuuming, I don't think postgres should ever behave like this, but I'm glad my problem is solved now. > > (perhaps this issue is fixed in newer releases, if not someone might want to look in to this pg_* tables/vacuum issue) As Jaime mentioned already, vacuuming is required. However, in addition to his point about various improvements, newer version will begin throwing errors as they get closer to txid wraparound, and will eventually shut down and refuse to run in multi-user mode once it reaches a certain point. So, yes, things have improved.