move postgresql to another disc if possible. You have really slow discs if that happen, or perhaps it does loads of seq scans, because of lack of indices. All in all, it seems like your server is to low spec for what you are trying to do. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general