Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5427D2E0033 for ; Mon, 26 Nov 2007 13:04:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20190-02 for ; Mon, 26 Nov 2007 13:04:54 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 6A45A2E00E5 for ; Mon, 26 Nov 2007 13:04:53 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so956821waf for ; Mon, 26 Nov 2007 09:04:52 -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:mime-version:content-type:content-transfer-encoding:content-disposition; bh=yOGFKHBkqLY4gakuw9yyvRaty15WPLocRHUkdqyq6L0=; b=QJ88rITk7Iw2vM1nhgyOop6g29f95eENLl5z3nTv0nJVhOvOOlJ5QrNvaMqjD5clHpjeQ+0CQjOIKwkcLPxnl8gkJGW2dSVYAX25mdtCcEnGisrUPZUP7jM/qJGqAUOnEFLZ3YDYw4kq3FtbhLO9Oer/wwXZHEFdhTv+cag5QJg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=XhMJN0RkUNJV2gyWuPiAlNy7sq39cOtq+KAEtGJ/YpKGBsoXXU36lNzxiA+GVs0LXEnBKo+gvz3cgfGaJq2eIFCingNI2hkBfpqg2bEp8r0ATSlj7G4yX4G+KzKgv09w/SIA5ceID9jvD3u0FOatw4pWngWffasdQaaHyFW/N28= Received: by 10.114.25.3 with SMTP id 3mr256568way.1196096690917; Mon, 26 Nov 2007 09:04:50 -0800 (PST) Received: by 10.114.199.9 with HTTP; Mon, 26 Nov 2007 09:04:50 -0800 (PST) Message-ID: <4544e0330711260904g45d893a8ub1731e245aa8fc84@mail.gmail.com> Date: Mon, 26 Nov 2007 11:04:50 -0600 From: "Peter Koczan" To: pgsql-performance Subject: TB-sized databases MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/299 X-Sequence-Number: 27714 Hi all, I have a user who is looking to store 500+ GB of data in a database (and when all the indexes and metadata are factored in, it's going to be more like 3-4 TB). He is wondering how well PostgreSQL scales with TB-sized databases and what can be done to help optimize them (mostly hardware and config parameters, maybe a little advocacy). I can't speak on that since I don't have any DBs approaching that size. The other part of this puzzle is that he's torn between MS SQL Server (running on Windows and unsupported by us) and PostgreSQL (running on Linux...which we would fully support). If any of you have ideas of how well PostgreSQL compares to SQL Server, especially in TB-sized databases, that would be much appreciated. We're running PG 8.2.5, by the way. Peter