Postgres Pro
Downloads
Home   >   mailing lists

Re: Query taking long time - Mailing list pgsql-performance

From Evgeniy Shishkin
Subject Re: Query taking long time
Date
Msg-id 793A3582-3AAE-477E-8AF3-8DA2C9133E20@gmail.com
Whole thread Raw
In response to Re: Query taking long time  ("acanada" <acanada@cnio.es>)
Responses Re: Query taking long time  ("acanada" <acanada@cnio.es>)
List pgsql-performance
Tree view 
On 07 Mar 2014, at 13:18, acanada <acanada@cnio.es> 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.

pgsql-performance by date:

Previous
From: Mohan Krishnan
Date:
Subject: Re: How can I get the query planner to use a bitmap index scap instead of an index scan ?
Next
From: "acanada"
Date:
Subject: Re: Query taking long time