One more follow up. Did a vacuum full on both tables and a re-index on both tables. Changed the wal_buffers to 16MB (increased the kernel param as a result) as per http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server I also turned off fsync but still no joy. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general