Re: high io BUT huge amount of free memory

On Mon, Apr 22, 2013 at 11:22 AM, Миша Тюрин <tmihail(at)bk(dot)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(at)postgresql(dot)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(dot)ru(at)gmail(dot)com