On 07 Mar 2014, at 13:18, acanada <acanada@xxxxxxx> wrote: > The table entity2document2 has 30GB. In consecutive runs it gets much better... 30ms apron. So you just benchmarking your hard drives with random iops. You need more ram and faster disks. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance