On 11/30/2011 09:32 AM, panam wrote:
Hi Filip, Thanks for the suggestions. There is no indication of disk activity triggered by postgres. iostat reports: Cannot find disk data (maybe because the system is hosted in a OpenVZ environment?) Systemlogs (syslog and postgresql-9.1-main.log) do not indicate something unusual. All pg threads are sleeping (S state). I will try to reproduce this, this time with a smaller initial disk size...
Try checking where the postgres processes are waiting, too: ps -C postgres -o wchan= -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general