running benchmark test on a 50GB database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: running benchmark test on a 50GB database
From: "Nuno Alves" <nuno.alexandre.alves@xxxxxxxxx>
Date: Wed, 20 Sep 2006 16:28:08 +0100

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

Follow-Ups:
- Re: running benchmark test on a 50GB database
  - From: Chris Mair
- Re: running benchmark test on a 50GB database
  - From: Dave Dutcher

Prev by Date: Re: Update on high concurrency OLTP application and Postgres
Next by Date: Re: running benchmark test on a 50GB database
Previous by thread: Update on high concurrency OLTP application and Postgres 8 tuning
Next by thread: Re: running benchmark test on a 50GB database
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux