Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51281=pgsql-performance-ar@postgresql.org>)
 id 1WN1S8-00051n-En
 for pgsql-performance@arkaria.postgresql.org; Mon, 10 Mar 2014 14:45:16 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51281=pgsql-performance-ar@postgresql.org>)
 id 1WN1S7-00048O-UY
 for pgsql-performance@arkaria.postgresql.org; Mon, 10 Mar 2014 14:45:15 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <itparanoia@gmail.com>) id 1WN1S7-00048A-0n
 for pgsql-performance@postgresql.org; Mon, 10 Mar 2014 14:45:15 +0000
Received: from mail-ie0-x22d.google.com ([2607:f8b0:4001:c03::22d])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <itparanoia@gmail.com>) id 1WN1S4-0000cl-I7
 for pgsql-performance@postgresql.org; Mon, 10 Mar 2014 14:45:14 +0000
Received: by mail-ie0-f173.google.com with SMTP id rl12so7271367iec.18
 for <pgsql-performance@postgresql.org>; Mon, 10 Mar 2014 07:45:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=content-type:mime-version:subject:from:in-reply-to:date:cc
 :content-transfer-encoding:message-id:references:to;
 bh=nbxSAfRtkBG8Lio+SEb+UaSRnjhEOUeCYwOqHMawO44=;
 b=t2LRvw8+vq8H4cayD05FU+C4iQolrHs15ktaFfQe6TV6bVtirf/3omDoCBO04cdh0u
 meR3IVqghKXCa9X1nswp/Y2+Yrm/LRhU+rHV8+/aWjuyrYRi+YwlvquVq7OKtPKiaAom
 1E/GooDDHMcHv1SWtfhfj4Tf+nkpNMUoEa98CEZb9UlynhGd+MPZAAtEy1ZK9BxUh7wB
 CgtvrPtKDN9h2xeVQ7PDa5vCioiunr5IdnNN1/jjXiA9QvTgzMBjJPj4DkAXAykrAqL2
 wmjGXLSEwim04kQLOg7rOizZZS5KkaZx3Y47lyGveg+tp73voCM5XCcbKvYLXAB/FWa8
 SJuQ==
X-Received: by 10.50.128.101 with SMTP id nn5mr18498017igb.7.1394462710847;
 Mon, 10 Mar 2014 07:45:10 -0700 (PDT)
Received: from wgaybook.corp.wargaming.local (by1-office.wargaming.net.
 [178.172.239.241])
 by mx.google.com with ESMTPSA id r6sm36805770igg.10.2014.03.10.07.45.08
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Mon, 10 Mar 2014 07:45:09 -0700 (PDT)
Content-Type: text/plain; charset=windows-1252
Mime-Version: 1.0 (Mac OS X Mail 7.1 \(1827\))
Subject: Re: Query taking long time
From: Evgeniy Shishkin <itparanoia@gmail.com>
In-Reply-To: <2A6C0749-A91C-4958-914C-847A0259CEC0@cnio.es>
Date: Mon, 10 Mar 2014 17:45:06 +0300
Cc: "pgsql-performance@postgresql.org list" <pgsql-performance@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <793A3582-3AAE-477E-8AF3-8DA2C9133E20@gmail.com>
References: 
 <3AE16087-DE09-4EE0-BDF7-F2DFC68CB6CB@cnio.es><FA02E6B1-9C0A-4122-8642-7D497D7DBB42@cnio.es><CAHBAh5v2MoPbsY8mSwV5N9pnPXatDjPT9LWac=sk4MtO1Bf1hA@mail.gmail.com><42CEB1D5-629F-490A-A99B-2E15B60CA6D1@cnio.es><CAHBAh5ubgT8UZ3_5avZDzdWDqB9KR82HoXuYyyGpP9Eu=u1QDQ@mail.gmail.com><964F1009-8714-4B4C-8386-45D3D7A95738@cnio.es><CAHBAh5s8_Q9hnHbNgEhukS1qGuz-Gzc0NZgKfj3B0vZYx6cUWw@mail.gmail.com><6F33D2DE-AC10-4B2F-9C56-BBBC77D28BE0@cnio.es><CAHBAh5s2RY=OhVbhxGTnoANT-LnQeTAgZUP2GaW2mdCP5efWKA@mail.gmail.com>
 <CAEs9oFmLNV-xn0QH+x1LsYhmNmWi-AQm1aB8F5YHMso7x2YWuA@mail.gmail.com>
 <99FD8F29-2E89-4B8B-9C9F-1B2A61139064@cnio.es>
 <7BCDBA11-D581-4B9F-97EC-3F6828F203AA@gmail.com>
 <6A1EC90E-4289-46A3-924A-799C0E158ACC@cnio.es>
 <EEC7C3BA-CDE9-4E28-880E-ECF5B0E9252E@gmail.com>
 <2A6C0749-A91C-4958-914C-847A0259CEC0@cnio.es>
To: acanada <acanada@cnio.es>
X-Mailer: Apple Mail (2.1827)
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


On 07 Mar 2014, at 13:18, acanada <acanada@cnio.es> wrote:

> The table entity2document2 has 30GB. In consecutive runs it gets much bet=
ter... 30ms apron.

So you just benchmarking your hard drives with random iops.

You need more ram and faster disks.

--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance