running benchmark test on a 50GB database

From: "Nuno Alves" <nuno(dot)alexandre(dot)alves(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: running benchmark test on a 50GB database
Date: 2006-09-20 15:28:08
Message-ID: 350f2a20609200828k7c16da77i8933a238e9de847b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2006-09-20 15:43:45 Re: running benchmark test on a 50GB database
Previous Message Cosimo Streppone 2006-09-20 12:22:30 Re: Update on high concurrency OLTP application and Postgres