Re: mosbench revisited - Mailing list pgsql-hackers

From Tom Lane
Subject Re: mosbench revisited
Date
Msg-id 3648.1312659030@sss.pgh.pa.us
Whole thread Raw
In response to Re: mosbench revisited  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: mosbench revisited
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> My experiments have shown that the freelist proper is not
> substantially faster than the freelist clocksweep--and that is even
> under the assumption that putting things back into the freelist is
> absolutely free.

The freelist isn't there to make buffer allocation faster, though;
it's there for allocation efficiency.  The point is that when some
buffers have become completely useless (eg, because we dropped the table
they were for), they'll be recycled in preference to reclaiming buffers
that contain still-possibly-useful data.  It would certainly be simple
to get rid of the freelist and only recycle dead buffers when the clock
sweep reaches them, but I think we'd be paying for that in extra,
unnecessary I/O.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Further news on Clang - spurious warnings
Next
From: Dimitri Fontaine
Date:
Subject: Re: Transient plans versus the SPI API