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.
.. and finally. When we retrieve the data from the command line, we get a 5720 ms retrieve time.
Any idea what could be causing the retrieval time discrepancies?
Thanks.
Joanne