Re: Dataset is fetched from cache but still takes same time to fetch records as first run

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Dataset is fetched from cache but still takes same time to fetch records as first run
From: Adam Brusselback <adambrusselback@xxxxxxxxx>
Date: Fri, 23 Jun 2017 08:09:49 -0400
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com header.b=Wq6o1P7R; spf=pass (google.com: best guess record for domain of pgsql-performance-owner+m55170=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-performance-owner+M55170=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:cc:to:subject:message-id :date:from:references:in-reply-to:mime-version:dkim-signature :arc-authentication-results; bh=ne/xZs0XANH3mCrASFYMu6fZRjLs6Zj6noyevv1RMZY=; b=poeW9kpGZ/MVjn2Ot+uLZm/s33sifN7TIcN9K+8M2HYEnka8r4CFx0KacMnXFclPSX wkwmTGOEo/XM62RTt6n8+ps4GgO13dWg9+YK7dEd7SdI2daLGAF/ZQ6f82B2yhUIIaTV AY8DhWShBfZUbAUW4GGnAbfJwZnc4EwI5FlbmNyhooAoPcTnqpfiGVmkZeUFOaoSW2/O /dx0rhl0YiKB34Eh7ZIgaWO9/GD2zJp2BDNROy8eJ1VAfctuVrKTUmnozOLHsLVny0dG kJHIyuF2Gten98BYOhH9VielweDIwNeMCcKRuUZsboKuGslR2E3oNfBgOyPolfX9szI1 Yp5w==
Arc-seal: i=1; a=rsa-sha256; t=1498219835; cv=none; d=google.com; s=arc-20160816; b=qpNz7qYuBWj9/j9E6vJf6870lh36IqNlVPYtltw5fZpxPlanebDUFnTYbVJ9isAREL I+Fqz9SX9vW14McctT9typU4ZUPfCJ7JhG1ueOcSAABXw0fJPus7vvJiLhzQ0lizCJmT Wy98kmQdfaFA5n/zpbP+vL4WU85m7k8ftv/7xPv3TbFdn4Ba6XzG+g3IyWJzMNAeZX83 R7gsPOEzrgA7SLsqZirXf9drj1XuSZxU/h/adjf/gc30Q6yA1bgiEV1R3zSoa3ZTL4b8 SJcy/cuT8gSJM7UBnMRE3NVurOXBMyIf2UynOq9/5MzEEL6OAnAvl+sWxnbYcsCnQ/Du 6pzw==
Cc: Sumeet Shukla <sumeet.k.shukla@xxxxxxxxx>, Dave Stibrany <dstibrany@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <19641.1498193431@sss.pgh.pa.us>
References: <CABUL137pc8pfW+KLm=7ucXpSDi_eG2qWiFMdR-3-UMEkZ=QUqA@mail.gmail.com> <CAK17Jmm6WBXy-4-_H21PAopoU5o=FyoLwjBkPeJCNHCU59z-Qw@mail.gmail.com> <CABUL136B8cKAxqaBh_2bHZXCOhRs8jOrAQP99DQ9RnE7xweucA@mail.gmail.com> <19641.1498193431@sss.pgh.pa.us>

On Fri, Jun 23, 2017 at 12:50 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

It's possible that pgAdmin4 has improved matters in this area.

Sadly, not in my experience. It's actually considerably worse than pgAdminIII in my experience when selecting a lot of rows, especially when very wide (20+ columns).

Follow-Ups:
- Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  - From: ldh@xxxxxxxxxxxxxxxxxx

References:
- Dataset is fetched from cache but still takes same time to fetch records as first run
  - From: Sumeet Shukla
- Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  - From: Dave Stibrany
- Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  - From: Sumeet Shukla
- Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  - From: Tom Lane

Prev by Date: Re: Inappropriate inner table for nested loop join
Next by Date: Re: Inappropriate inner table for nested loop join
Previous by thread: Re: Dataset is fetched from cache but still takes same time to fetch records as first run
Next by thread: Re: Dataset is fetched from cache but still takes same time to fetch records as first run
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]