Thanks Well I tried it out and on OS/2 using 8.0 it has the same problems as on Linux, with two clients running on a dual PIII 750 both CPUs go to 100% and the system is madly switching between the two processes. With a single client, about 35% CPU is used.
Should the new buffer manager patch eliminate this behaviour? That is what I gathered from the discussions. Lorne In <[EMAIL PROTECTED]>, on 02/20/05 at 02:01 PM, Tom Lane <[EMAIL PROTECTED]> said: >[EMAIL PROTECTED] writes: >> There was a mention of a "context-swap-storm" test in the posts on the ARC >> patent. Where might I obtain a copy of this test procedure? >http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php >(The archiver seems to have lost the message's separation into parts, but >the "setup" script is the part down through the checkpoint command.) >Read the whole thread for context. > regards, tom lane >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings -- ----------------------------------------------------------- [EMAIL PROTECTED] ----------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend