> 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
We don't know what your database looks like, what the
queries are you're running, what "very, very
slow" means for you and what version of PostgreSQL
on what OS this is :/
The two links are a good starting point to tuning your DB:
http://www.postgresql.org/docs/8.1/static/performance-tips.html
http://www.powerpostgresql.com/PerfList/
Bye, Chris.