Re: Postgresql is very slow

bijayant kumar wrote:
>  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