optimalization - Mailing list pgsql-performance

From croolyc
Subject optimalization
Date
Msg-id AANLkTi=4CfFBhwJM5iU4VbUFEHB3g5r5SRkL+GuS8Zc_@mail.gmail.com
Whole thread Raw
Responses Re: optimalization  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-performance
Hi!
can you help me with performance optimization
on my machine I have 8 databases with ca. 1-2GB

processor is:
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E3110  @ 3.00GHz
stepping        : 10
cpu MHz         : 2992.585
cache size      : 6144 KB
physical id     : 0
siblings        : 2
core id         : 0
cpu cores       : 2
...
processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E3110  @ 3.00GHz
stepping        : 10
cpu MHz         : 2992.585
cache size      : 6144 KB
physical id     : 0
siblings        : 2
core id         : 1
cpu cores       : 2
...
memory: 8GB (4*2GB ecc ram)

hdd: raid 1 (mdadm) - 2x 500GB, ext4 (mounted for /var, without /var/log)

powered with UPS

my English is not very good and I completely lost track while reading
the user manual
i find something like that
http://samiux.wordpress.com/2009/07/26/howto-performance-tuning-for-postgresql-on-ubuntudebian/
but i,m not so sure, reading mha220 comments, that is safe for me & my server :/

greatings

pgsql-performance by date:

Previous
From: Selva manickaraja
Date:
Subject: Load and Stress on PostgreSQL 9.0
Next
From: Andreas Kretschmer
Date:
Subject: Re: optimalization