From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: scan_recycle_buffers |
Date: | 2007-03-10 00:13:35 |
Message-ID: | 1173485615.23455.7.camel@dogma.v10.wvs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Fri, 2007-03-09 at 20:37 +0000, Simon Riggs wrote:
> > 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.
>
> Jeff's patch does this also, for similar reasons.
>
As Tom pointed out, the value is already in memory by the time it gets
to my code. My code just reads that value from memory.
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2007-03-10 00:17:34 | Re: scan_recycle_buffers |
Previous Message | Dave Page | 2007-03-10 00:00:46 | Re: who gets paid for this |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2007-03-10 00:17:34 | Re: scan_recycle_buffers |
Previous Message | Tom Lane | 2007-03-09 23:05:38 | Re: scan_recycle_buffers |