Re: [GENERAL] heavy swapping, not sure why

2011-08-29 Thread peixubin
You should monitor PageTables value in /proc/meminfo.if the value larger than 1G,I Suggest enable hugepages . To monitor PageTables: # cat /proc/meminfo |grep -i pagetables -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] table full scan or index full scan?

2009-10-12 Thread peixubin
I understood , thanks. --- 09年10月12日,周一, Martijn van Oosterhout 写道: 发件人: Martijn van Oosterhout 主题: Re: [GENERAL] table full scan or index full scan? 收件人: "Peter Hunsberger" 抄送: "Scott Marlowe" , " ??" , pgsql-general@postgresql.org 日期: 2009年10月12日,周一,下午2:25 On Sun, Oct 11, 2009 at 10:01