Re: Slow update with simple query

Поиск
Список
Период
Сортировка
От Arnaud Lesauvage
Тема Re: Slow update with simple query
Дата
Msg-id 45817B2F.7070502@freesurf.fr
обсуждение исходный текст
Ответ на Re: Slow update with simple query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane a écrit :
> I think the conclusion must be that there was just too much I/O to be
> done to update all the rows.  Have you done any tuning of shared_buffers
> and so forth?  I recall having seen cases where update performance went
> bad as soon as the upper levels of a large index no longer fit into
> shared_buffers ...

Yes, that's probably it.
I think my raid1 array's performances are very bad.
I am switching to a brand new hardware next week, I am quite confident that this
will solve many problems.

Thanks for helping !

Regards
--
Arnaud


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow update with simple query
Следующее
От: Evgeny Gridasov
Дата:
Сообщение: Re: EXPLAIN ANALYZE on 8.2