Re: insert performance for win32 - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: insert performance for win32
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD7D3@Herge.rcsinc.local
Whole thread Raw
In response to insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
Responses Re: insert performance for win32  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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.


Merlin


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Searching union views not using indices
Next
From: Tom Lane
Date:
Subject: Re: insert performance for win32