Nailed it.

problem is in mainloop.c -> setup_cancel_handler.  Apparently you can
have multiple handlers and windows keeps track of them all, even if they
do the same thing.  Keeping track of so many system handles would
naturally slow the whole process down.  Commenting that line times are
flat as a pancake.  I am thinking keeping track of a global flag would
be appropriate.  


---------------------------(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

Reply via email to