| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-performance(at)postgresql(dot)org>, "Marc Cousin" <mcousin(at)sigma(dot)fr> |
| Subject: | Re: insert performance for win32 |
| Date: | 2005-11-04 17:56:02 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3417DD7D3@Herge.rcsinc.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2005-11-04 17:57:24 | Re: [OT] somebody could explain this? |
| Previous Message | Bruno Wolff III | 2005-11-04 17:53:43 | Re: [OT] somebody could explain this? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-11-04 18:01:20 | Re: insert performance for win32 |
| Previous Message | Tom Lane | 2005-11-04 17:53:07 | Re: Searching union views not using indices |