Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M54856=pgsql-performance-ar@postgresql.org>)
	id 1cj4rX-0008Km-HD
	for pgsql-performance@arkaria.postgresql.org; Wed, 01 Mar 2017 14:04:15 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-performance-owner+M54856=pgsql-performance-ar@postgresql.org>)
	id 1cj4rX-0001mT-48
	for pgsql-performance@arkaria.postgresql.org; Wed, 01 Mar 2017 14:04:15 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <srkunze@mail.de>)
	id 1cj4pk-0006ty-Ne
	for pgsql-performance@postgresql.org; Wed, 01 Mar 2017 14:02:24 +0000
Received: from shout02.mail.de ([2001:868:100:600::217])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <srkunze@mail.de>)
	id 1cj4pi-0005Mr-QB
	for pgsql-performance@postgresql.org; Wed, 01 Mar 2017 14:02:24 +0000
Received: from postfix01.mail.de (postfix01.bt.mail.de [10.0.121.125])
	by shout02.mail.de (Postfix) with ESMTP id 1DCFB69A41;
	Wed,  1 Mar 2017 15:02:21 +0100 (CET)
Received: from smtp01.mail.de (smtp01.bt.mail.de [10.0.121.211])
	by postfix01.mail.de (Postfix) with ESMTP id 04BD240087;
	Wed,  1 Mar 2017 15:02:21 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=mail.de;
	s=mailde201610; t=1488376941;
	bh=SBHkfKImctR4NP0RGrBLjfPDSzWy9s/4aIbNK9cR4O8=;
	h=Subject:To:References:Cc:From:Date:In-Reply-To:From;
	b=gCYSGvGpTwoVpbYmzUdoAJtpRVi7DfkNzYwiqtcbWgIQB0R7/tQeaVFk4MAlfxrJ1
	 tVgGhnjR47X7A5Chgksk9JHT/EkBK2fSlvNxoQYW+0+v6vogtqY4nHNar4CgwLpe+d
	 1QXzVl/6dCIjBK7ziNVK2Tw7wqWPqyxpkbUEmcsI=
Received: from [127.0.0.1] (localhost [127.0.0.1])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by smtp01.mail.de (Postfix) with ESMTPSA id CD68240478;
	Wed,  1 Mar 2017 15:02:15 +0100 (CET)
Subject: Re: Speeding up JSON + TSQUERY + GIN
To: Jeff Janes <jeff.janes@gmail.com>
References: <2260e4e6-89ae-90dc-278c-81243b3c3510@mail.de>
 <CAMkU=1xyf5ypGew=cgFuczQHqtc59J1CTf2EugF0hwSWu65ZCA@mail.gmail.com>
 <cffa8be6-4e43-7399-2f7a-5686f65acda2@mail.de>
 <CAMkU=1yWkWfZEZ=ANm-bWrDHBm869MCyRmyJDx5kbeCwJC_w2Q@mail.gmail.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
From: "Sven R. Kunze" <srkunze@mail.de>
Message-ID: <b10df25c-c796-2cf0-60c0-040c31bc99a9@mail.de>
Date: Wed, 1 Mar 2017 15:02:15 +0100
MIME-Version: 1.0
In-Reply-To: 
 <CAMkU=1yWkWfZEZ=ANm-bWrDHBm869MCyRmyJDx5kbeCwJC_w2Q@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------9A6945457A1421AF822C4E6E"
X-purgate: clean
X-purgate: This mail is considered clean (visit http://www.eleven.de for
 further information)
X-purgate-type: clean
X-purgate-Ad: Categorized by eleven eXpurgate (R) http://www.eleven.de
X-purgate: This mail is considered clean (visit http://www.eleven.de for
 further information)
X-purgate: clean
X-purgate-size: 2009
X-purgate-ID: 154282::1488376940-0000088C-A173D617/0/0
X-Spam-Status: No, score=-1.0 required=10.0 tests=ALL_TRUSTED,BAYES_20,
	FREEMAIL_FROM,HTML_MESSAGE autolearn=no autolearn_force=no version=3.4.1
X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on
	spamassassin01.mail.de
X-Pg-Spam-Score: -2.7 (--)
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

This is a multi-part message in MIME format.
--------------9A6945457A1421AF822C4E6E
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

On 28.02.2017 17:49, Jeff Janes wrote:
> Oh.  In my hands, it works very well.  I get 70 seconds to do the 
> {age: 20} query from pure cold caches, versus 1.4 seconds from cold 
> caches which was followed by pg_prewarm('docs','prefetch').
>
> How much RAM do you have?  Maybe you don't have enough to hold the 
> table in RAM.  What kind of IO system?  And what OS?

On my test system:

RAM: 4GB
IO: SSD (random_page_cost = 1.0)
OS: Ubuntu 16.04

Regards,
Sven


--------------9A6945457A1421AF822C4E6E
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 28.02.2017 17:49, Jeff Janes wrote:<br>
    </div>
    <blockquote
cite="mid:CAMkU=1yWkWfZEZ=ANm-bWrDHBm869MCyRmyJDx5kbeCwJC_w2Q@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div class="gmail_extra">
          <div class="gmail_quote">Oh.  In my hands, it works very
            well.  I get 70 seconds to do the {age: 20} query from pure
            cold caches, versus 1.4 seconds from cold caches which was
            followed by pg_prewarm('docs','prefetch').
            <div><br>
            </div>
            <div>How much RAM do you have?  Maybe you don't have enough
              to hold the table in RAM.  What kind of IO system?  And
              what OS?<br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    On my test system:<br>
    <br>
    RAM: 4GB<br>
    IO: SSD (random_page_cost = 1.0)<br>
    OS: Ubuntu 16.04<br>
    <br>
    Regards,<br>
    Sven<br>
    <br>
  </body>
</html>

--------------9A6945457A1421AF822C4E6E--