Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D1DE82E31F0 for ; Tue, 27 Nov 2007 16:57:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 87777-05 for ; Tue, 27 Nov 2007 16:57:09 -0400 (AST) Received: from outmail137070.authsmtp.co.uk (outmail137070.authsmtp.co.uk [62.13.137.70]) by postgresql.org (Postfix) with ESMTP id CF39B2E3218 for ; Tue, 27 Nov 2007 16:57:11 -0400 (AST) Received: from outmail128176.authsmtp.co.uk (outmail128176.authsmtp.co.uk [62.13.128.176]) by punt4.authsmtp.com (8.14.1/8.14.1/Kp) with ESMTP id lARKv7s0025882; Tue, 27 Nov 2007 20:57:07 GMT Received: from [192.168.0.3] (85-211-24-246.dyn.gotadsl.co.uk [85.211.24.246]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id lARKv5Gi091113; Tue, 27 Nov 2007 20:57:05 GMT Subject: Re: TB-sized databases From: Simon Riggs To: Peter Koczan Cc: pgsql-performance In-Reply-To: <4544e0330711271218h56ce4cc3p280a9fefff24583d@mail.gmail.com> References: <4544e0330711260904g45d893a8ub1731e245aa8fc84@mail.gmail.com> <474B1407.3090607@laotraesquina.com.ar> <474B1B8C.1030505@gmail.com> <4544e0330711271218h56ce4cc3p280a9fefff24583d@mail.gmail.com> Content-Type: text/plain Date: Tue, 27 Nov 2007 20:57:25 +0000 Message-Id: <1196197045.4246.1154.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 50148c5c-9d2b-11dc-814e-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagJbY1ZH HGQLW1NEUl17XGR/ aw0fZQBDYEtPQQdu TkpNRE1QERpoT0Bw ZGVYV24rdwxHeX9z K0dmWHgVWUR7cU4u Rx1JHDkEN3phaTRM TUhZc1ZJcANLfxdA PlN4UyBcLwdSbGoL JyIJERcLGAAXFA4Q WQAfIF5aTU8XFzQ1 XB0ZdXVz X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/327 X-Sequence-Number: 27742 On Tue, 2007-11-27 at 14:18 -0600, Peter Koczan wrote: > Thanks all. This is just what I needed. All of those responses have cooked up quite a few topics into one. Large databases might mean text warehouses, XML message stores, relational archives and fact-based business data warehouses. The main thing is that TB-sized databases are performance critical. So it all depends upon your workload really as to how well PostgreSQL, or another other RDBMS vendor can handle them. Anyway, my reason for replying to this thread is that I'm planning changes for PostgreSQL 8.4+ that will make allow us to get bigger and faster databases. If anybody has specific concerns then I'd like to hear them so I can consider those things in the planning stages. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com