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 20000526160144.E28594@fw.wintelcom.net
обсуждение исходный текст
Ответ на Re: Update Performance from 6.5.0 to 6.5.3 to 7.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
* Tom Lane <tgl@sss.pgh.pa.us> [000526 15:43] wrote:
> "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?

I'm quite sure we experianced the same problem (mutliple indexes causing
slow update/inserts) when we moved an identical table structure from
6.5 to 7.0

-Alfred

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance issue 6.5 versus 7.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Speed of locating tables?