Skip site navigation (1) Skip section navigation (2)

Re: sloooow query

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: "Marie G(dot) Tuite" <marie(dot)tuite(at)edisonaffiliates(dot)com>
Cc: "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>,pgsql-performance(at)postgresql(dot)org
Subject: Re: sloooow query
Date: 2002-10-08 00:03:08
Message-ID: 20021008000308.GA28930@svana.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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(at)svana(dot)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.

In response to

pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2002-10-08 05:44:11
Subject: Re: [pgsql-performance] Large databases, performance
Previous:From: Marie G. TuiteDate: 2002-10-07 22:12:41
Subject: Re: sloooow query

pgsql-general by date

Next:From: Nigel J. AndrewsDate: 2002-10-08 00:36:59
Subject: Re: PLTCL return_null crash...
Previous:From: Greg StarkDate: 2002-10-07 22:49:08
Subject: Design question, Does postgres provide a simpler solution than the obvious?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group