Re: Postgresql is very slow - Mailing list pgsql-performance

From Jeremy Harris
Subject Re: Postgresql is very slow
Date
Msg-id 485FA6DC.9090204@wizmail.org
Whole thread Raw
In response to Postgresql is very slow  (bijayant kumar <bijayant4u@yahoo.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Jan de Visser
Date:
Subject: Re: Postgresql is very slow
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Postgresql is very slow