Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dOCeP-000259-1p for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 00:40:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dOCeO-0008RI-HP for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 00:40:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dOCeN-0008MW-4e for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 00:40:39 +0000 Received: from mail-io0-x22e.google.com ([2607:f8b0:4001:c06::22e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dOCeK-0000Te-L0 for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 00:40:37 +0000 Received: by mail-io0-x22e.google.com with SMTP id j24so5092940ioi.3 for ; Thu, 22 Jun 2017 17:40:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=0yUCBD2MtgwdRLcdNcJbaFdexxzc1AjUqLOCzuHK3Ys=; b=pUjk5xdYZFfFxsYj1NDTvKWTd2XMeh6/40HUXUNR0D6AnOG/XahfJAlArSI3SNuqwh +rP420mEc+jJcLSa4prkzqdnet4Zg5rE9LXQToHEW4XbW7QZw7Ar8JA6znNbdPYZNwh3 2VpUQ1816Tn+7dMR3oP9Qkkt0Ic0tJ950wzcY0+uaWnNLVlMd9MRAteHfY7uj9z/tKIb xV5141XdUyMIwVRTySgaYQwTPOZxmcx0GnuZLRqeqKZWXpqZAKDtPJKe2Uc7pqF3+K19 QU3+U+wO3R172oZb38OSrqgB5uuZZYJZlGu9yaDaDIfOQaVJq74Xz/0RCBla2Ew7ioU0 iDmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=0yUCBD2MtgwdRLcdNcJbaFdexxzc1AjUqLOCzuHK3Ys=; b=qxNMzBS6zPRRcufUltNnlcPGN9DGOlOU6nBM6Kmq9qUafEGX66o+X4Pknb7WS8cKCQ 1tujarqKZbjmy+rnfdiOM7CVFr0QHLmD1rX5RaBjngND9bdTj3NlVyviOBb+OOx0cVG3 BRsXFFlmSIugUMz9xkossfdmqz5UrimRaQCY3oZRuXfdMKMe15UVyEzCekrQDuSDp+Ni Td3RoQkJjfspeU8nTwcdDHW0DD7LIzWCwJdZ97sHs6C7AajXFiTkB2+CQB3CpQE/vVA3 aZ14OYfvH50WGAxDKnje+3/lmC4w4oAkxbRvFzPQb3qHkkHY/7ph3jZ10gGOXWYelu0Y O4nQ== X-Gm-Message-State: AKS2vOx7i55b+guOOP4mwEAuXKs2mNQfKvPLh+Qns4EO8EcvhX0g48E6 AxQx8zJYPMP5NYZLt8mpZ0lvoszjd1KoTVo= X-Received: by 10.107.15.27 with SMTP id x27mr4803856ioi.107.1498178435629; Thu, 22 Jun 2017 17:40:35 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.22.7 with HTTP; Thu, 22 Jun 2017 17:40:35 -0700 (PDT) From: Sumeet Shukla Date: Thu, 22 Jun 2017 19:40:35 -0500 Message-ID: Subject: Dataset is fetched from cache but still takes same time to fetch records as first run To: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary="001a113f1e6477748e055295d94c" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --001a113f1e6477748e055295d94c Content-Type: text/plain; charset="UTF-8" Both the first run and subsequent run takes same amount of time. *First Run:* "Seq Scan on d_payer (cost=0.00..8610.40 rows=121788 width=133) (actual time=8.760..98.582 rows=121788 loops=1)" " *Buffers: shared read=2521*" "Planning time: 16.820 ms" "Execution time: 108.626 ms" *Second Run:* "Seq Scan on d_payer (cost=0.00..8610.40 rows=121788 width=133) (actual time=0.010..18.456 rows=121788 loops=1)" " *Buffers: shared hit=2521*" "Planning time: 0.083 ms" "Execution time: 27.288 ms" Can anyone please help me understand and fix this. Thanks & Regards, Sumeet Shukla --001a113f1e6477748e055295d94c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Both the first run and subsequent run takes same amount of= time.

First Run:

"Seq Scan on d_payer (cost=3D0= .00..8610.40 rows=3D121788 width=3D133) (actual time=3D8.760..98.582 rows= =3D121788 loops=3D1)"
"=C2=A0Buffers: shared=C2=A0read=3D2521"
"P= lanning time: 16.820 ms"
"Execution time: 108.626 ms"

=


Second Run:

"S= eq Scan on d_payer (cost=3D0.00..8610.40 rows=3D121788 width=3D133) (actual= time=3D0.010..18.456 rows=3D121788 loops=3D1)"
"=C2=A0Buffers: shared=C2=A0hit=3D2521<= /strong>"
"Planning time: 0.083 ms"
"Execution ti= me: 27.288 ms"


Can anyone please help me understand and fix this= .


Thanks & Regards,
Sumee= t Shukla

<= /div>
--001a113f1e6477748e055295d94c--