Re: Query taking long time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux