pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Neil Conway <neilc@samurai.com>
To: LIANHE SHAO <lshao2@jhmi.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: very large db performance question
Date: Wed, 26 Nov 2003 17:03:31 -0500
Message-ID: <87u14q6b4c.fsf@mailbox.samurai.com> (raw)
In-Reply-To: <4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu>
References: <4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu>

LIANHE SHAO <lshao2@jhmi.edu> writes:
> We will have a very large database to store microarray data (may
> exceed 80-100G some day). now we have 1G RAM, 2G Hz Pentium 4, 1
> CPU. and enough hard disk.

> Could anybody tell me that our hardware is an issue or not?

IMHO the size of the DB is less relevant than the query workload. For
example, if you're storying 100GB of data but only doing a single
index scan on it every 10 seconds, any modern machine with enough HD
space should be fine.

If you give us an idea of the # of queries you expect per second, the
approximate mix of reads and writes, and some idea of how complex the
queries are, we might be able to give you some better advice.

-Neil





view thread (6+ messages)  latest in thread

Message-ID: <87u14q6b4c.fsf@mailbox.samurai.com>
Permalink:  ../87u14q6b4c.fsf@mailbox.samurai.com/
Also on:    postgresql.org/message-id/87u14q6b4c.fsf@mailbox.samurai.com

 · 

reply

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: neilc@samurai.com, lshao2@jhmi.edu
  Subject: Re: very large db performance question
  In-Reply-To: <87u14q6b4c.fsf@mailbox.samurai.com>

* 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