Re: Hardware Requirements - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Hardware Requirements
Date
Msg-id CAGTBQpY=D8k5ndo6ZYyKW4p7QM4pXgsx0EhnxzDL0PZ4q8jDHQ@mail.gmail.com
Whole thread Raw
In response to Hardware Requirements  (Vivekanand Joshi <vjoshi@zetainteractive.com>)
List pgsql-performance

On Tue, Dec 9, 2014 at 3:42 PM, Vivekanand Joshi <vjoshi@zetainteractive.com> wrote:
What I actually want to achieve is right now is that running the same load on Netezza and PostgreSQL [300 GB data, 20 concurrent queries, and 30k-40K queries in an hour].


You will need to provide far more information about the type of queries you're referring to.

Querying one single row against a PK isn't the same as performing complex analytics on big chunks of historical data.

pgsql-performance by date:

Previous
From: Vivekanand Joshi
Date:
Subject: Hardware Requirements
Next
From: Bruce Momjian
Date:
Subject: Re: intel s3500 -- hot stuff