From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Laurent Laborde <kerdezixe(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: high shared buffer and swap |
Date: | 2009-05-04 15:07:45 |
Message-ID: | dcc563d10905040807h6a88dd51o2683ed6105454ac0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
On Mon, May 4, 2009 at 2:10 AM, Laurent Laborde <kerdezixe(at)gmail(dot)com> wrote:
> Friendly greetings !
> I found something "odd" (something that i can't explain) this weekend.
>
> An octocore server with 32GB of ram, running postgresql 8.3.6
> Running only postgresql, slony-I and pgbouncer.
>
> Just for testing purpose, i tried a setting with 26GB of shared_buffer.
>
> I quickly noticed that the performances wasn't very good and the
> server started to swap slowly but surely.
> (but still up to 2000query/second as reported by pgfouine)
>
> It used all the 2GB of swap.
> I removed the server from production, added 10GB of swap and left it
> for the weekend with only slony and postgresql up to keep it in sync
> with the master database.
>
> This morning i found that the whole 12GB of swap were used :
> Mem: 32892008k total, 32714728k used, 177280k free, 70872k buffers
> Swap: 12582896k total, 12531812k used, 51084k free, 27047696k cached
Try setting swappiness =0.
But as someone else mentioned, I've alwas had better luck letting the
OS do most of the caching anyway.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-05-04 16:07:59 | Re: windows shared memory error |
Previous Message | Peter Eisentraut | 2009-05-04 14:52:12 | Re: hellow Postmaster and Postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | Vlad Arkhipov | 2009-05-05 07:31:24 | Limit I/O bandwidth of a certain backend |
Previous Message | Martijn van Oosterhout | 2009-05-04 10:15:09 | Re: [HACKERS] high shared buffer and swap |