Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id CAD102E0038 for ; Thu, 10 Jan 2008 07:09:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 26451-01 for ; Thu, 10 Jan 2008 07:08:54 -0400 (AST) Received: from hu-out-0506.google.com (hu-out-0506.google.com [72.14.214.227]) by postgresql.org (Postfix) with ESMTP id 68E0E2E0170 for ; Thu, 10 Jan 2008 07:08:58 -0400 (AST) Received: by hu-out-0506.google.com with SMTP id 22so235601hug.23 for ; Thu, 10 Jan 2008 03:08:56 -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:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=1zyAg4b5XcQmkTyJOAZ6DLKPxbS9164fedgvv+O4DbU=; b=KD6IrkdRq/i74WKTpQQRLKCDlZGzi3JexM76mNNAwoI2QtLvophXDCIyXc1GzbXCcHOnw1L7t1Np7gOsMLfqEQJc9lpb7Co5eYDbo57VNuTX2eJMIJ3obbfHMx5eqahNszuE7wehk0KmTbfZ60O84aC8w0j5ubNRXEz+Mgj65Dg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=RWOIpG+UAV2F+ZVTaTp/JT23glbQ06hr3QDuz3PU4RCyOKPErNDubYHEXc5O0qR6sfoSzfx8Qy5ro8/I/kYsKj+16dJ47GcN3ukWmBM7u4E81AfA9xEYYXXqC9cw25G4WjoU+hBTF9sHWxe69tmzpPW4xtbLfp2EZyUynxjzjSo= Received: by 10.67.32.7 with SMTP id k7mr3388785ugj.46.1199963336266; Thu, 10 Jan 2008 03:08:56 -0800 (PST) Received: from ?192.168.1.118? ( [89.251.0.64]) by mx.google.com with ESMTPS id e23sm7279617ugd.56.2008.01.10.03.08.54 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 10 Jan 2008 03:08:55 -0800 (PST) Message-ID: <4785FCB7.3090403@gmail.com> Date: Thu, 10 Jan 2008 12:08:39 +0100 From: Stephane Bailliez User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Jared Mauch CC: pgsql-performance@postgresql.org Subject: Re: big database performance References: <4784835A.8070604@careerjunction.co.za> <47848575.8000007@commandprompt.com> <20080109174243.GA8915@puck.nether.net> In-Reply-To: <20080109174243.GA8915@puck.nether.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/52 X-Sequence-Number: 28291 Jared Mauch wrote: > I do large databases in Pg, like 300GB/day of new data. That's impressive. Would it be possible to have details on your hardware, schema and configuration and type of usage ? I'm sure there's something to learn in there for a lot of people (or at least for me) Cheers, -- stephane