| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Autovacuum Improvements |
| Date: | 2007-01-26 04:13:20 |
| Message-ID: | 16600.1169784800@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iannsp | 2007-01-26 04:15:22 | DBLink contrib used for replication |
| Previous Message | Tom Lane | 2007-01-26 04:06:50 | Re: Problem loading pg_dump file |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-01-26 04:39:00 | Re: [GENERAL] Autovacuum Improvements |
| Previous Message | Jan Wieck | 2007-01-26 03:19:06 | Proposal: Snapshot cloning |