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.graichen@innominate.com
innominate AG
the linux architects
tel: +49-30-308806-13 fax: -77 http://www.innominate.com