From: Sven R. Kunze <srkunze@mail.de>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Speeding up JSON + TSQUERY + GIN
Date: Wed, 1 Mar 2017 15:02:15 +0100
Message-ID: <b10df25c-c796-2cf0-60c0-040c31bc99a9@mail.de> (raw)
In-Reply-To: <CAMkU=1yWkWfZEZ=ANm-bWrDHBm869MCyRmyJDx5kbeCwJC_w2Q@mail.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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: srkunze@mail.de, jeff.janes@gmail.com
Subject: Re: Speeding up JSON + TSQUERY + GIN
In-Reply-To: <b10df25c-c796-2cf0-60c0-040c31bc99a9@mail.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox