| From: | croolyc <croolists(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | optimalization |
| Date: | 2011-02-28 09:41:31 |
| Message-ID: | AANLkTi=4CfFBhwJM5iU4VbUFEHB3g5r5SRkL+GuS8Zc_@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | croolyc | 2011-02-28 09:43:53 | optimization |
| Previous Message | Marc Cousin | 2011-02-28 09:38:04 | inheritance: planning time vs children number vs column number |