Re: 8.3devel slower than 8.2 under read-only load

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: 8.3devel slower than 8.2 under read-only load
Дата
Msg-id 874pf8dhwt.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: 8.3devel slower than 8.2 under read-only load  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: 8.3devel slower than 8.2 under read-only load  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:

> I've written up my suggestion as a 5 line patch, with measured
> performance improvement of about 40% for the varchar case. 

A 5-line patch which improves performance by 40% for any case sounds amazing,
but how fragile is that gain? The kind of thing which would be worryign is if
runing a query which uses both varchar and some other ambiguous operator
causes it to lose all its gain.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!


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

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: maintenance_work_mem memory constraint?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.3devel slower than 8.2 under read-only load