From: Jeremy Harris <jgh@wizmail.org>
To: pgsql-performance@postgresql.org
Subject: Re: Postgresql is very slow
Date: Mon, 23 Jun 2008 14:36:28 +0100
Message-ID: <485FA6DC.9090204@wizmail.org> (raw)
In-Reply-To: <306870.66258.qm@web32707.mail.mud.yahoo.com>
References: <306870.66258.qm@web32707.mail.mud.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jgh@wizmail.org
Subject: Re: Postgresql is very slow
In-Reply-To: <485FA6DC.9090204@wizmail.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox