Thread: optimalization
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
croolyc <croolists@gmail.com> wrote: > Hi! > can you help me with performance optimization > on my machine I have 8 databases with ca. 1-2GB Performace optimization depends on the workload... Is that a dedicated server, only for PostgreSQL? I assume it. > memory: 8GB (4*2GB ecc ram) Okay, as a first try, set shared_buffers to 2 GByte, and increase work_mem up to, maybe, 20 MByte. You can (and should) set log_min_duration_statement, maybe to 1000 (1000ms), and observe the log. Read our docu about EXPLAIN, and analyse long-running queries with EXPLAIN (ANALYSE). And again, performance tuning depends on the real workload on the server, it's hard to give you a recipe for all use-cases. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°