Re: Update Performance from 6.5.0 to 6.5.3 to 7.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Update Performance from 6.5.0 to 6.5.3 to 7.0
Дата
Msg-id 3738.959378084@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Update Performance from 6.5.0 to 6.5.3 to 7.0  ("Bryan White" <bryan@arcamax.com>)
Ответы Re: Update Performance from 6.5.0 to 6.5.3 to 7.0  (Alfred Perlstein <bright@wintelcom.net>)
Список pgsql-general
"Bryan White" <bryan@arcamax.com> writes:
>>>> 4, I could probably get by with just 2 If I had to.  I will give it a
>>>> try.

> With the indexes deleted I am now getting 40 or 50 updates per second
> instead of 5.

That's good, but does it mean that 7.0 is slower about adding index
entries than 6.5 was?  Or did you have fewer indexes on the table
when you were using 6.5?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Speed of locating tables?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: INSERT/UPDATE in views fail silently