Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dONPU-0005IR-BF for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 12:10:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dONPT-00088D-Pd for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 12:09:59 +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 ) id 1dONPT-000880-5x for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 12:09:59 +0000 Received: from mail-ua0-x22a.google.com ([2607:f8b0:400c:c08::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dONPL-0007V4-OP for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 12:09:58 +0000 Received: by mail-ua0-x22a.google.com with SMTP id 70so35763287uau.0 for ; Fri, 23 Jun 2017 05:09:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=ne/xZs0XANH3mCrASFYMu6fZRjLs6Zj6noyevv1RMZY=; b=Wq6o1P7R/Vk/wUBwaCsRipNNtdQp5FRsXGbiVqGWo0vq+jRQm9KB855E3YLQXjTFAG lU+Suan3hCRltHB5SOv8+0DBTR+vmjEdeU7yf4T/MrrzmteC54Dl+/1g06Vy2321MKup M5MV/BQ50oJKVGOzdBb2I5wN2849FGTOah9/vn08U/3PKzt2GLkbc24ps5fdXRZtuAtp 0E5SbuhG6bk/qOqUj0r90uLO1Mwfq9Vc8+DBkaUc4tWuRU0rZTzLvItUKkXpma6/L+tu +9kclaz8T+Suj72h5TOyRSX6j4CJd0h3hmHILjWxyuiR71lQZp0bqksFGcTvj2/nCSRA 4HSQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=ne/xZs0XANH3mCrASFYMu6fZRjLs6Zj6noyevv1RMZY=; b=jQTOsRFMIySzbZeihFWSNjCHdu8huHx8TEP/NAtpOP0H2QqK01PZpB7iY7zxlon0jD Tx2pAY3wzo5HkdGuLa05elwSBvZs4ZnMZEngbfxzaVtdvI9pUCh0PAqSS08Lg5F354F3 or9eUYN1VYPLwoiBDnv6xeztepqZw++3NmWpf/3ciyfG0PYGKtBR2LrOkH43rrFjlTaE OLsuxSff3XoYKuHMU46YXOp10D6SiRxDfnI+u+xPPkF2uKNHVloryy5xpaMmsxBTc3I1 xQvUTajw9NZD3inO/7XTW5KoC+8xqh1rCjzI5iJgXS+3QjheAyjmLXiBt/B7nzNEmKZK v6nw== X-Gm-Message-State: AKS2vOwf3XpP15F0hq/21J25P/YMuvjcZct7sQwYDRp0xL7g2v0bM5af 5yFZzIsf4V7cNlUupivkHzJaK6qm0w== X-Received: by 10.176.3.164 with SMTP id 33mr5966823uau.53.1498219789929; Fri, 23 Jun 2017 05:09:49 -0700 (PDT) MIME-Version: 1.0 Received: by 10.176.82.49 with HTTP; Fri, 23 Jun 2017 05:09:49 -0700 (PDT) In-Reply-To: <19641.1498193431@sss.pgh.pa.us> References: <19641.1498193431@sss.pgh.pa.us> From: Adam Brusselback Date: Fri, 23 Jun 2017 08:09:49 -0400 Message-ID: Subject: Re: Dataset is fetched from cache but still takes same time to fetch records as first run To: Tom Lane Cc: Sumeet Shukla , Dave Stibrany , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary="94eb2c06c4465fd52105529f7ac3" 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 --94eb2c06c4465fd52105529f7ac3 Content-Type: text/plain; charset="UTF-8" On Fri, Jun 23, 2017 at 12:50 AM, Tom Lane 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). --94eb2c06c4465fd52105529f7ac3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On F= ri, Jun 23, 2017 at 12:50 AM, Tom Lane <tgl@sss.pgh.pa.us> w= rote:
It's possible that pgAdmin4 has improved matters in this area.

Sadly= , not in my experience.=C2=A0 It's actually considerably worse than pgA= dminIII in my experience when selecting a lot of rows, especially when very= wide (20+ columns).
--94eb2c06c4465fd52105529f7ac3--