Skip site navigation (1) Skip section navigation (2)

Re: postgres & smp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Graichen <graichen(at)innominate(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres & smp
Date: 2001-02-18 16:30:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Thomas Graichen <news-list(dot)pgsql(dot)admin(at)innominate(dot)de> writes:
> 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

Hm, did you set commit_delay to zero?  What are the other postmaster
parameters (especially -B) ?

			regards, tom lane

In response to


pgsql-admin by date

Next:From: Dmitry MorozovskyDate: 2001-02-18 19:36:03
Subject: Re: v7.1b4 bad performance
Previous:From: Thomas GraichenDate: 2001-02-18 11:36:38
Subject: Re: postgres & smp

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group