On Mon, Apr 22, 2013 at 11:22 AM, Миша Тюрин <tmih...@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...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers