Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: extending relations more efficiently
On Tue, May 1, 2012 at 3:08 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote: > We've previously discussed the possible desirability of extending > relations in larger increments, rather than one block at a time, for > performance reasons. I attempted to determine how much performance we > could possibly buy this way, and found that, as far as I can see, the > answer is, basically, none. Fair enough, but my understanding was that tests showed that the extension lock was a bottleneck, so doing extensions in larger chunks should reduce the time we spend waiting for a lock and thus improve performance. So while your results here show no gain, there is gain to be had elsewhere as a result. The algorithm needs to be adaptive, so we don't waste space on smaller tables or lower loads. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
In response to
- extending relations more efficiently at 2012-05-01 14:08:27 from Robert Haas
Responses
- Re: extending relations more efficiently at 2012-05-01 14:56:49 from Robert Haas
- Re: extending relations more efficiently at 2012-05-01 17:12:55 from Christopher Browne
pgsql-hackers by date
Next: From: Robert Haas Date: 2012-05-01 14:25:53 Subject: Re: proposal: additional error fields Previous: From: Kevin Grittner Date: 2012-05-01 14:08:57 Subject: Re: proposal: additional error fields