Re: sloooow query

Martijn van Oosterhout <kleptog@svana.org>

From: Martijn van Oosterhout <kleptog@svana.org>
To: "Marie G. Tuite" <marie.tuite@edisonaffiliates.com>
Cc: "Pgsql-General@Postgresql. Org" <pgsql-general@postgresql.org>, pgsql-performance@postgresql.org
Date: 2002-10-08T00:03:08Z
Lists: pgsql-performance, pgsql-general
On Mon, Oct 07, 2002 at 02:22:09PM -0500, Marie G. Tuite wrote:
> Hello all,
> 
> I am experiencing slow db performance.  I have vacuumed, analyzed, reindexed
> using the force option and performance remains the same - dog-slow :(  If I
> drop and recreate the database, performance is normal, so this suggests a
> problem with the indexes?  I also took a look at the postgresql.conf and all
> appears fine.  There are many instances of the same database running on
> different servers and not all servers are experiencing the problem.

We need more details if you wish to receive useful answers. Query/EXPLAIN
output/schema, etc

-- 
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.