View Single Post

   
  #3 (permalink)  
Old 04-18-2008, 01:20 AM
Tom Lane
 
Posts: n/a
Default Re: ignore_killed_tuples is always true

Jaime Casanova <systemguards@gmail.com> writes:
> On 2/10/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> What is the point of removing it? You cannot argue that saving
>> one if-test per tuple is a worthwhile speedup.


> to clean code?


It's not saving any noticeable amount of code, and what it is doing
is removing functionality we might want someday. It's not hard to
imagine pgstattuple or VACUUM or other maintenance operations wanting
to look at killed index entries.

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