Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6B3536500E5 for ; Mon, 3 Nov 2008 12:04:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55339-07 for ; Mon, 3 Nov 2008 12:04:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.233]) by mail.postgresql.org (Postfix) with ESMTP id C39BB650074 for ; Mon, 3 Nov 2008 12:04:58 -0400 (AST) Received: by rv-out-0506.google.com with SMTP id b25so2461350rvf.43 for ; Mon, 03 Nov 2008 08:04:57 -0800 (PST) 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=ZwpTN1ZdxM+EJZ0SJsxXWKPXnzhOVjcUthbqqPQS7ig=; b=AvLuEbh6CUVlv/qZZ2BdQOB7NC+HN3AWD+VkeFkcs0/PgGsqcmC0ZveH91UrKF9Fbc 101BzwARuh8/fqJiIRteqj8K4ZJsny3JqyYNffjomlKASq5WZrXPJKWCq6xgfg5UPDab E7xQXcs3bb4a3Ny70J6MSztwUDiQWGYahfvys= 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=qDJxl9UNrU+xUJYRclSo7sRgsawDvkBSlAFR4HBVnGEFMokapGJ/01ZEalwuqVn/C4 snZlEZPH9TxbaGcKQ2ryN1OIk/wR1MhGV/pAJ9J3yD/xibQE4Y/1Z3TIctr4f6GKM73O RLvAxLrR2C+MfBUmFdXH372fxc1R1VMieKd2c= Received: by 10.115.58.1 with SMTP id l1mr198680wak.27.1225728297762; Mon, 03 Nov 2008 08:04:57 -0800 (PST) Received: by 10.114.39.11 with HTTP; Mon, 3 Nov 2008 08:04:57 -0800 (PST) Message-ID: Date: Mon, 3 Nov 2008 09:04:57 -0700 From: "Scott Marlowe" To: matthieu.roger@gene6.com Subject: Re: Crash with pg_clog file not found Cc: pgsql-admin@postgresql.org In-Reply-To: <30111ec50811030749h5f2da74bq3d3c071ea26d764a@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <30111ec50811022341q688ca946j8269cee93b206a3d@mail.gmail.com> <25898.1225722884@sss.pgh.pa.us> <30111ec50811030749h5f2da74bq3d3c071ea26d764a@mail.gmail.com> X-Archive-Number: 200811/13 X-Sequence-Number: 30667 On Mon, Nov 3, 2008 at 8:49 AM, Matthieu Roger wrote: > > 8.3.3 was also producing the same error, prior version (8.3.1) did not > seem to exhibit it, though we've opened a new universe in the web game > which increased the number of accounts and players in september so > maybe this triggers the problem. I know you probably don't want to hear this right now, but PostgreSQL can handle a much higher load under some flavor of unix than it can under windows. Luckily, it's pretty easy to set up a machine running Centos5, Ubuntu 8.x or some other flavor of linux. Due to basic architectural differences, the difference isn't likely to change soon.