View Single Post

   
  #4 (permalink)  
Old 04-18-2008, 10:40 AM
Tom Lane
 
Posts: n/a
Default Re: scan_recycle_buffers

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote