> 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.
