Postgres Pro
Downloads
Home   >   mailing lists

running benchmark test on a 50GB database - Mailing list pgsql-performance

From Nuno Alves
Subject running benchmark test on a 50GB database
Date
Msg-id 350f2a20609200828k7c16da77i8933a238e9de847b@mail.gmail.com
Whole thread Raw
Responses Re: running benchmark test on a 50GB database
Re: running benchmark test on a 50GB database
List pgsql-performance
Tree view 
Hi,

I am running bechmark test in a 50 GB postgresql database.
I have the postgresql.conf with all parameters by default.
In this configuration the database is very, very slow.

Could you please tell which is the best configuration?

My system:
Pentium D 3.0Ghz
RAM: 1GB
HD: 150GB SATA

Thanks in advance,
Nuno

pgsql-performance by date:

Previous
From: Cosimo Streppone
Date:
Subject: Re: Update on high concurrency OLTP application and Postgres
Next
From: "Dave Dutcher"
Date:
Subject: Re: running benchmark test on a 50GB database