Re: High load,

Cédric, thanks a lot for your answer so far!

On Thu, Jan 27, 2011 at 12:24 PM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:

> you have swap used, IO on the swap partition ?

Memory-wise we are fine.

> can you paste the /proc/meminfo ?

Sure:

# cat /proc/meminfo
MemTotal:       16461012 kB
MemFree:          280440 kB
Buffers:           60984 kB
Cached:         13757080 kB
SwapCached:         6112 kB
Active:          7049744 kB
Inactive:        7716308 kB
Active(anon):    2743696 kB
Inactive(anon):  2498056 kB
Active(file):    4306048 kB
Inactive(file):  5218252 kB
Unevictable:           0 kB
Mlocked:               0 kB
SwapTotal:        999992 kB
SwapFree:         989496 kB
Dirty:              3500 kB
Writeback:             0 kB
AnonPages:        943752 kB
Mapped:          4114916 kB
Shmem:           4293312 kB
Slab:             247036 kB
SReclaimable:     212788 kB
SUnreclaim:        34248 kB
KernelStack:        3144 kB
PageTables:       832768 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:     9230496 kB
Committed_AS:    5651528 kB
VmallocTotal:   34359738367 kB
VmallocUsed:       51060 kB
VmallocChunk:   34350787468 kB
HardwareCorrupted:     0 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:        7936 kB
DirectMap2M:    16760832 kB

> Also turn on log_checkpoint if it is not already and check the
> duration to write the data.

Will do, thanks!

> You didn't said the DB size (and size of active part of it), it would help here.

=> select pg_size_pretty(pg_database_size('xxx'));
 pg_size_pretty
----------------
 32 GB
(1 row)

> it is too much with 200 connections. you may experiment case where you
> try to use more than the memory available.

So far memory never really was a problem, but I'll keep these
suggestions in mind.

> 16MB should work well

We already thought of increasing that, will do so now.

>> effective_cache_size = 8192MB
>
> 12-14GB looks better

Thank you, I was rather unsure on this on.

> you use full_text_search ?

Not anymore, probably a leftover.

> do you monitor the 'locks' ? and the commit/rollbacks  ?

No, but I'll look into doing that.

Thanks a lot for the feedback again,
Michael