Re: SMP buffer management test question

From: lsunley(at)mb(dot)sympatico(dot)ca
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: SMP buffer management test question
Date: 2005-02-20 22:49:58
Message-ID: 0IC800K0RIFAJ0@l-daemon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 <15517(dot)1108926080(at)sss(dot)pgh(dot)pa(dot)us>, on 02/20/05
at 02:01 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> said:

>lsunley(at)mb(dot)sympatico(dot)ca 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

--
-----------------------------------------------------------
lsunley(at)mb(dot)sympatico(dot)ca
-----------------------------------------------------------

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-21 01:28:50 Re: SMP buffer management test question
Previous Message Tom Lane 2005-02-20 22:10:42 Can we remove SnapshotSelf?