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

From Jeff Davis
Subject Re: extending relations more efficiently
Date
Msg-id 1338491870.6178.10.camel@sussancws0025
Whole thread Raw
In response to extending relations more efficiently  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Tue, 2012-05-01 at 10:08 -0400, Robert Haas 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.

Another point here is that with checksums, we will want to make sure
that zero pages can be treated as corrupt. That will probably involve
using the WAL for extension operations, and we'll want to mitigate that
cost somehow. Extending in larger chunks would probably be necessary.

There are some challenges there, but I think it's worth pursuing.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: \conninfo and SSL
Next
From: Merlin Moncure
Date:
Subject: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile