| 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: | Whole Thread | Raw Message | 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 |