pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Performance in a 7 TB database.
2+ messages / 2 participants
[nested] [flat]

* Performance in a 7 TB database.
@ 2006-09-08 09:30  Nuno Alexandre Alves <naalves@criticalsoftware.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Nuno Alexandre Alves @ 2006-09-08 09:30 UTC (permalink / raw)
  To: pgsql-performance

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?

Thanks is advance,
Nuno
DISCLAIMER: This message may contain confidential information or privileged material and is intended only for the individual(s) named. If you are not a named addressee and mistakenly received this message you should not copy or otherwise disseminate it: please delete this e-mail from your system and notify the sender immediately. E-mail transmissions are not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. Therefore, the sender does not accept liability for any errors or omissions in the contents of this message that arise as a result of e-mail transmissions. Please request a hard copy version if verification is required. Critical Software, SA.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Performance in a 7 TB database.
@ 2006-09-08 16:19  Jeff Davis <pgsql@j-davis.com>
  parent: Nuno Alexandre Alves <naalves@criticalsoftware.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jeff Davis @ 2006-09-08 16:19 UTC (permalink / raw)
  To: Nuno Alexandre Alves <naalves@criticalsoftware.com>; +Cc: pgsql-performance

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2006-09-08 16:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-08 09:30 Performance in a 7 TB database. Nuno Alexandre Alves <naalves@criticalsoftware.com>
2006-09-08 16:19 ` Jeff Davis <pgsql@j-davis.com>

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