From: Jeff Davis <pgsql@j-davis.com>
To: Nuno Alexandre Alves <naalves@criticalsoftware.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance in a 7 TB database.
Date: Fri, 08 Sep 2006 09:19:00 -0700
Message-ID: <1157732340.4393.6.camel@dogma.v10.wvs> (raw)
In-Reply-To: <4501384C.4000506@criticalsoftware.com>
References: <4501384C.4000506@criticalsoftware.com>
On Fri, 2006-09-08 at 10:30 +0100, Nuno Alexandre Alves wrote:
> Hi,
>
> I have a customer who wants a database solution for a 7 TB database.
> Insert will be the main action in the database.
>
> There are some case studies with detail information about performance
> and hardware solution on this database size?
> What are the minimum hardware requirements for this kind of database?
>
This is a good place to start:
http://www.postgresql.org/about/users
I would expect that the case studies for databases greater than 7TB are
few and far between (for any database software). If you decide
PostgreSQL is right, I'm sure the advocacy mailing list would like to
see your case study when you are finished.
Your hardware requirements mostly depend on how you're going to use the
data. If you expect that most of the data will never be read, and that
the database will be more of an archive, the requirements might be quite
reasonable. However, if or when you do need to search through that data,
expect it to take a long time.
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, naalves@criticalsoftware.com
Subject: Re: Performance in a 7 TB database.
In-Reply-To: <1157732340.4393.6.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox