Re: Postgresql is very slow

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgresql is very slow
Date: 2008-06-23 13:36:28
Message-ID: 485FA6DC.9090204@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2008-06-23 13:50:14 Re: Postgresql is very slow
Previous Message Jan de Visser 2008-06-23 12:35:58 Re: Postgresql is very slow