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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: [email protected] <[email protected]>
To: Adam Brusselback <[email protected]>
To: Tom Lane <[email protected]>
Cc: Sumeet Shukla <[email protected]>
Cc: Dave Stibrany <[email protected]>
Cc: pgsql-performa. <[email protected]>
Subject: Re: Dataset is fetched from cache but still takes same time to fetch records as first run
Date: Fri, 23 Jun 2017 16:55:03 +0000
Message-ID: <BN4PR15MB0547CEA4CDCD3067EECD9A3285D80@BN4PR15MB0547.namprd15.prod.outlook.com> (raw)
In-Reply-To: <CAMjNa7dpP4Smz0KSGCWbxK_8_9WUETY5wuzmn=FRKaGZGTHtxA@mail.gmail.com>
References: <CABUL137pc8pfW+KLm=7ucXpSDi_eG2qWiFMdR-3-UMEkZ=QUqA@mail.gmail.com>
	<CAK17Jmm6WBXy-4-_H21PAopoU5o=FyoLwjBkPeJCNHCU59z-Qw@mail.gmail.com>
	<CABUL136B8cKAxqaBh_2bHZXCOhRs8jOrAQP99DQ9RnE7xweucA@mail.gmail.com>
	<[email protected]>
	<CAMjNa7dpP4Smz0KSGCWbxK_8_9WUETY5wuzmn=FRKaGZGTHtxA@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

ditto here... much slower, and crashes too often. We run an evergreen shop where I work, but everyone has moved back to III.

Sent from my BlackBerry KEYone - the most secure mobile device
From: [email protected]
Sent: June 23, 2017 8:11 AM
To: [email protected]
Cc: [email protected]; [email protected]; [email protected]
Subject: Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run


On Fri, Jun 23, 2017 at 12:50 AM, Tom Lane <[email protected]<mailto:[email protected]>> 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).

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  In-Reply-To: <BN4PR15MB0547CEA4CDCD3067EECD9A3285D80@BN4PR15MB0547.namprd15.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox