>From: Tom Lane <[email protected]> >To: Sumeet Shukla <[email protected]> >Cc: Dave Stibrany <[email protected]>; [email protected] >Sent: Friday, 23 June 2017, 5:50 >Subject: Re: [PERFORM] Dataset is fetched from cache but still takes same time >to fetch records as first run > Sumeet Shukla <[email protected]> writes:> >> Yes, but when I actually execute the query in pgAdmin3, it takes exactly >> the same time of 19.5 secs. > >pgAdmin is well known to be horribly inefficient at displaying large >query results (and 121788 rows qualifies as "large" for this purpose, >I believe). The circa-tenth-of-a-second savings on the server side >is getting swamped by client-side processing. > >It's possible that pgAdmin4 has improved matters in this area.
> It's also possibly time taken for the results to be tranferred over a network if the data is large. Glyn -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
