Re: [GENERAL] sloooow query

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: [GENERAL] sloooow query
Дата
Msg-id 20021008000308.GA28930@svana.org
обсуждение исходный текст
Ответ на sloooow query  ("Marie G. Tuite" <marie.tuite@edisonaffiliates.com>)
Список 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 по дате отправления:

Предыдущее
От: "Marie G. Tuite"
Дата:
Сообщение: Re: sloooow query
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: [GENERAL] Large databases, performance