Re: Relation extension scalability - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Relation extension scalability
Date
Msg-id 20160202170650.GA135006@alvherre.pgsql
Whole thread Raw
In response to Re: Relation extension scalability  (Andres Freund <andres@anarazel.de>)
List 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 by date:

Previous
From: David Steele
Date:
Subject: Re: Add generate_series(date, date) and generate_series(date, date, integer)
Next
From: Teodor Sigaev
Date:
Subject: Re: Tsvector editing functions