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
