postgres & smp

From: Thomas Graichen <news-list(dot)pgsql(dot)admin(at)innominate(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres & smp
Date: 2001-02-18 11:16:18
Message-ID: news2mail-96oau2$prm$1@mate.bln.innominate.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

i hope this list is somewhat the right one for this ...

i did some small tests with postgresql-71.beta4 on various
filesystems (ext2, reiserfs, xfs) on two machines: 1 single
cpu and one 2 cpu smp and was a bit surprised to see the tps
results of the smp case to be lower than the one of the up case
(also the running times of the used pgbench said the same)
... i was thinking that the load should spread over the cpu's
and thus expected better results for smp - is there anything
to take care of for smp with postgresql? did i anything
wrong here?

a lot of thanks in advance

t

p.s.: btw. i in all cases see about 15% better results with
the database running on an xfs filesystem compared to
ext2 ... reiserfs is about the same as ext2 but some-
times even worse ... just if anyone is interested ...

--
thomas(dot)graichen(at)innominate(dot)com
innominate AG
the linux architects
tel: +49-30-308806-13 fax: -77 http://www.innominate.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Graichen 2001-02-18 11:36:38 Re: postgres & smp
Previous Message Katsuyuki Tanaka 2001-02-18 04:27:47 IPC Shared Memory