Re: scan_recycle_buffers - Mailing list pgsql-patches

From Tom Lane
Subject Re: scan_recycle_buffers
Date
Msg-id 3522.1173476740@sss.pgh.pa.us
Whole thread Raw
In response to Re: scan_recycle_buffers  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: scan_recycle_buffers  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> I wonder if calling RelationGetNumberOfBlocks on every seq scan becomes
> a performance issue for tiny tables with for example just 1 page. It
> performs an lseek, which isn't free.

We do that anyway; but certainly Simon's patch ought not be injecting
an additional one.

            regards, tom lane

pgsql-patches by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: scan_recycle_buffers
Next
From: "Simon Riggs"
Date:
Subject: Re: scan_recycle_buffers