No title

Started by Mark Wongabout 22 years ago2 messageshackers
Jump to latest
#1Mark Wong
markw@osdl.org

http://developer.osdl.org/markw/ia64/dbt2/

I have a summary of intial results from our DBT-2 workload with
PostgreSQL 7.4.1 on a 4-way Itanium2 system with 16GB of memory and 56
drives using LVM2 and linux-2.6.3. There's readprofile
and oprofile data, but oprofile is seg faulting when it's trying to
generate the annotated assembly source.

I'm still trying to get a feel for how large of a database I can run
with it, but I wanted to share what I've got so far. It looks like I
have quite a bit of unused system resources, so I probably have to tune
the database and perhaps how I'm driving the load a bit.

Let me know if there are any questions.

--
Mark Wong - - markw@osdl.org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 626-2455 x 32 (office)
(503) 626-2436 (fax)
http://developer.osdl.org/markw/

#2David Mosberger
davidm@napali.hpl.hp.com
In reply to: Mark Wong (#1)
dbt-2 tests & profiling on ia64

Mark,

On Mon, 23 Feb 2004 09:42:34 -0800 (PST), markw@osdl.org said:

Mark> http://developer.osdl.org/markw/ia64/dbt2/
Mark> I have a summary of intial results from our DBT-2 workload with
Mark> PostgreSQL 7.4.1 on a 4-way Itanium2 system with 16GB of memory and 56
Mark> drives using LVM2 and linux-2.6.3. There's readprofile
Mark> and oprofile data, but oprofile is seg faulting when it's trying to
Mark> generate the annotated assembly source.

You could try q-tools, see the announcement here:

http://marc.theaimsgroup.com/?l=linux-ia64&m=107075994721581

Besides the flat profile, it will also give you call-counts. (It
would be nice if this feature could be added to oprofile some day.)

--david