Thread: optimalization

optimalization

From
croolyc
Date:
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

Re: optimalization

From
Andreas Kretschmer
Date:
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°