Re: [PERFORM] running benchmark test on a 50GB database

2006-09-20 Thread Jim C. Nasby
On Wed, Sep 20, 2006 at 05:47:41PM +0200, Chris Mair wrote: > > > 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 co

Re: [PERFORM] running benchmark test on a 50GB database

2006-09-20 Thread Chris Mair
> 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 S

Re: [PERFORM] running benchmark test on a 50GB database

2006-09-20 Thread Dave Dutcher
10:28 AM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] running benchmark test on a 50GB database > > > 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 dat

[PERFORM] running benchmark test on a 50GB database

2006-09-20 Thread Nuno Alves
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