pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
optimalization 2+ messages / 2 participants [nested] [flat]
* optimalization @ 2011-02-28 09:41 croolyc <croolists@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: croolyc @ 2011-02-28 09:41 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: optimalization @ 2011-02-28 18:32 Andreas Kretschmer <akretschmer@spamfence.net> parent: croolyc <croolists@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Andreas Kretschmer @ 2011-02-28 18:32 UTC (permalink / raw) To: pgsql-performance 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° ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-02-28 18:32 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-02-28 09:41 optimalization croolyc <croolists@gmail.com> 2011-02-28 18:32 ` Andreas Kretschmer <akretschmer@spamfence.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox