On 11/10/15 9:39 AM, Mammarelli, Joanne T wrote:
Hi – same rookie user as before.
We have one table
100,000 rows
80 columns
When we try to retrieve the data (select * from table) using pgadmin, we
get a 193456 ms retrieve time.
When I ran a query analyze in the command prompt, we get a 316ms
retrieve time.
You mean EXPLAIN ANALYZE?
.. and finally. When we retrieve the data from the command line, we get
a 5720 ms retrieve time.
What was psql doing with the output?
Basically, pgAdmin and psql aren't meant for users to deal with huge
data sets, because humans don't deal well with huge data sets.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
