Re: [GENERAL] sloooow query - Mailing list pgsql-performance

From Martijn van Oosterhout
Subject Re: [GENERAL] sloooow query
Date
Msg-id 20021008000308.GA28930@svana.org
Whole thread Raw
In response to sloooow query  ("Marie G. Tuite" <marie.tuite@edisonaffiliates.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: "Marie G. Tuite"
Date:
Subject: Re: sloooow query
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: [GENERAL] Large databases, performance