Re: very large db performance question - Mailing list pgsql-performance

From Eric Jain
Subject Re: very large db performance question
Date
Msg-id 00bf01c3f541$ead47f60$c300000a@caliente
Whole thread Raw
In response to very large db performance question  (LIANHE SHAO <lshao2@jhmi.edu>)
List pgsql-performance
> 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.


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow response of PostgreSQL
Next
From: "Saleem Burhani Baloch"
Date:
Subject: Re: Slow response of PostgreSQL