> select * from tablename takes 10-15 mins to give the output
There are better ways to dump data than using a database; that's
not a useful query.
> Any query select,insert,update simple or complex behaves in the same way
Have you set up suitable indexes for your operations (and then run analyze)?
Cheers,
Jeremy
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
No comments:
Post a Comment