Re: Update Performance from 6.5.0 to 6.5.3 to 7.0

Поиск
Список
Период
Сортировка
От Alfred Perlstein
Тема Re: Update Performance from 6.5.0 to 6.5.3 to 7.0
Дата
Msg-id 20000526151359.C28594@fw.wintelcom.net
обсуждение исходный текст
Ответ на Re: Update Performance from 6.5.0 to 6.5.3 to 7.0  ("Bryan White" <bryan@arcamax.com>)
Список pgsql-general
* Bryan White <bryan@arcamax.com> [000526 13:59] wrote:
> > > 4, I could probably get by with just 2 If I had to.  I will give it a
> try.
> >
> > yes! this should fix it for you.
>
> With the indexes deleted I am now getting 40 or 50 updates per second
> instead of 5.

It concerns me that with 6.5 this sort of operation with multiple indecies
was fine and now it's slow.

Can anyone explain it?

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

В списке pgsql-general по дате отправления:

Предыдущее
От: b.saunders@mindspring.com
Дата:
Сообщение: Failed regression tests
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: Performance issue 6.5 versus 7.0