sloooow query

Поиск
Список
Период
Сортировка
Искать

sloooow query

От:
"Marie G. Tuite" <marie.tuite@edisonaffiliates.com>
Дата:
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.

Thanks in advance for any suggestions.

Marie


Re: sloooow query

От:
Martijn van Oosterhout <kleptog@svana.org>
Дата:
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      http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
FAQ