Skip site navigation (1) Skip section navigation (2)

optimization

From: croolyc <croolists(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: optimization
Date: 2011-02-28 09:43:53
Message-ID: AANLkTimDPhR+71a5Xrh8Jjf-91j2XrPE45ZF8YWyzrVp@mail.gmail.com (view raw or flat)
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

Responses

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2011-02-28 11:30:48
Subject: Re: Performance Test for PostgreSQL9
Previous:From: croolycDate: 2011-02-28 09:41:31
Subject: optimalization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group