Re: high io BUT huge amount of free memory - Mailing list pgsql-hackers

From Sergey Konoplev
Subject Re: high io BUT huge amount of free memory
Date
Msg-id CAL_0b1sG9oGCxnbj5aDgL=NGjamZihhwBydomgi51jQiuuG4Sw@mail.gmail.com
Whole thread Raw
In response to high io BUT huge amount of free memory  (Миша Тюрин <tmihail@bk.ru>)
List pgsql-hackers
On Mon, Apr 22, 2013 at 11:22 AM, Миша Тюрин <tmihail@bk.ru> wrote:
> free -g
>              total       used       free     shared    buffers     cached
> Mem:           378        250        128          0          0        229
> -/+ buffers/cache:         20        357
>
> and
> ! disks usage 100%  (free 128GB! WHY?)
>
> disk throughput - up-to 30MB/s (24r+6w)
> io - up-to 2,5-3K/s (0,5w + 2-2,5r)

What do iostat -xk 10 and vmstat -SM 10 show?


>
> 3) so maybe I've got something like this
> http://www.databasesoup.com/2012/04/red-hat-kernel-cache-clearing-issue.html
> or this
> http://comments.gmane.org/gmane.comp.db.sqlite.general/79457
>
> 4) now i think
> a) upgrade linux core or
> b) set buffers to something like 300-320Gb
> my warm work set is about 300-400GB
> db at all - 700GB
>
> typical work load - pk-index-scans
>
> --
> looking forward
> thanks
>>
> Mikhail
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>



--
Kind regards,
Sergey Konoplev
Database and Software Consultant

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray.ru@gmail.com



pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: Performance with the new security release?
Next
From: Jeff Davis
Date:
Subject: Re: Enabling Checksums