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

Re: multibyte performance

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: hannu(at)tm(dot)ee
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: multibyte performance
Date: 2001-09-27 12:30:38
Message-ID: 20010927213038L.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
> > With multibyte support(first column is the concurrent user, second is
> > the TPS):
> ...
> > 32 95.947363
> > 64 92.718780
> > 128 61.725883
> > 
> > Witout multibyte support:
> ...
> > 32 92.283645
> > 64 86.936559
> > 128 87.584099
> 
> Do you have any theory why multibyte passes non-mb at 128 ?
> 
> Some subtle timing thing perhaps (or just bad luck for non-mb at 128)?

May be or may not be. I was anxious about the load module size and
thought it might stress the memory. So while running pgbench I checked
the memory usage using vmstat. However it showed no excess page
in/page out...
--
Tatsuo Ishii

In response to

pgsql-hackers by date

Next:From: Haller ChristophDate: 2001-09-27 12:59:47
Subject: Re: Abort transaction on duplicate key error
Previous:From: Haller ChristophDate: 2001-09-27 11:27:09
Subject: Abort transaction on duplicate key error

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