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 |
