Slow response if pulling through pgadmin - Mailing list pgsql-general

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