Re: Relation extension scalability

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Relation extension scalability
Дата
Msg-id 20160202170650.GA135006@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Relation extension scalability  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund wrote:

> Could you also measure how this behaves for [...]

While we're proposing benchmark cases -- I remember this being an issue
with toast tables getting very large values of xml which causes multiple
toast pages to be extended for each new value inserted.  If there are
multiple processes inserting these all the time, things get clogged.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: David Steele
Дата:
Сообщение: Re: Add generate_series(date, date) and generate_series(date, date, integer)
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Tsvector editing functions