If I've done this correctly, there should not be anywhere near the number of context switches we currently see while sorting.
Each unscheduled context switch represents something unexpected occuring or things not being where they are needed when they are needed. Reducing such circumstances to the absolute minimum was one of the design goals. Reducing the total amount of IO to the absolute minimum should help as well. Ron -----Original Message----- From: Kevin Grittner <[EMAIL PROTECTED]> Sent: Sep 27, 2005 11:21 AM Subject: Re: [HACKERS] [PERFORM] A Better External Sort? I can't help wondering how a couple thousand context switches per second would affect the attempt to load disk info into the L1 and L2 caches. That's pretty much the low end of what I see when the server is under any significant load. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
