Re: extending relations more efficiently - Mailing list pgsql-hackers

From Jeroen Vermeulen
Subject Re: extending relations more efficiently
Date
Msg-id 4FA1177C.4030405@xs4all.nl
Whole thread Raw
In response to Re: extending relations more efficiently  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: extending relations more efficiently
List pgsql-hackers
On 2012-05-01 22:06, Robert Haas wrote:

> It might also be interesting to provide a mechanism to pre-extend a
> relation to a certain number of blocks, though if we did that we'd
> have to make sure that autovac got the memo not to truncate those
> pages away again.

Good point.  And just to check before skipping over it, do we know that 
autovacuum not leaving enough slack space is not a significant cause of 
the bottlenecks in the first place?


Jeroen


pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Analyzing foreign tables & memory problems
Next
From: Hannu Krosing
Date:
Subject: How hard would it be to support LIKE in return declaration of generic record function calls ?