From: Eric Jain <Eric.Jain@isb-sib.ch>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: very large db performance question
Date: Tue, 17 Feb 2004 11:36:35 +0100
Message-ID: <00bf01c3f541$ead47f60$c300000a@caliente> (raw)
References: <4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu>
<87u14q6b4c.fsf@mailbox.samurai.com>
> 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.
I agree that the workload is likely to be the main issue in most
situations. However, if your queries involve lots of counting and
aggregating, your databases contains several gigabytes of data, and you
are using common hardware, be prepared to wait anywhere from minutes to
hours, even if you are the only user.
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: Eric.Jain@isb-sib.ch
Subject: Re: very large db performance question
In-Reply-To: <00bf01c3f541$ead47f60$c300000a@caliente>
* 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