From: tv@fuzzy.cz
To: bijayant4u@yahoo.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql is very slow
Date: Mon, 23 Jun 2008 15:50:14 +0200 (CEST)
Message-ID: <20229.217.77.161.17.1214229014.squirrel@sq.gransy.com> (raw)
In-Reply-To: <306870.66258.qm@web32707.mail.mud.yahoo.com>
References: <306870.66258.qm@web32707.mail.mud.yahoo.com>
Hi,
> Hello to list,
>
> We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling
> with postgresql performance. Any query say select * from tablename takes
> 10-15 mins to give the output, and while executing the query system loads
> goes up like anything. After the query output, system loads starts
> decresing.
I doubt the 'select * from tablename' is a good candidate for tuning, but
give us more information about the table. What is it's size - how many
rows does it have and how much space does it occupy on the disk? What is a
typical usage of the table - is it modified (update / delete) frequently?
How is it maintained - is there a autovacuum running, or did you set a
routine vacuum (and analyze) job to maintain the database?
I guess one of the servers (the slow one) is running for a long time
without a proper db maintenance (vacuum / analyze) and you dumped / loaded
the db onto a new server. So the 'new server' has much more 'compact'
tables and thus gives the responses much faster. And this holds for more
complicated queries (with indexes etc) too.
An output from 'EXPLAIN' (or 'EXPLAIN ANALYZE') command would give a much
better overview.
Tomas
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: tv@fuzzy.cz, bijayant4u@yahoo.com
Subject: Re: Postgresql is very slow
In-Reply-To: <20229.217.77.161.17.1214229014.squirrel@sq.gransy.com>
* 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