Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Jim C. Nasby wrote:
>> If we extended relations by more than one page at a time we'd probably
>> have a better shot at the blocks on disk being contiguous and all read
>> at the same time by the OS.
> Actually, there is evidence that adding only a single page to the end
> causes a lot of contention for that last page, and that adding a few
> might be better.
Evidence where? The code is designed so that the last page *isn't*
shared --- go read the comments in hio.c sometime.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2007-01-26 04:39:00|
|Subject: Re: [GENERAL] Autovacuum Improvements|
|Previous:||From: Jan Wieck||Date: 2007-01-26 03:19:06|
|Subject: Proposal: Snapshot cloning|
pgsql-general by date
|Next:||From: Iannsp||Date: 2007-01-26 04:15:22|
|Subject: DBLink contrib used for replication|
|Previous:||From: Tom Lane||Date: 2007-01-26 04:06:50|
|Subject: Re: Problem loading pg_dump file |