Re: [HACKERS] multibyte performance

2001-09-29 Thread Tatsuo Ishii
> > I did some benchmarking with/without multibyte support using current. > > (1) regression test > > (2) pgbench > > pgbench unfortunately seems quite irrelevant to this issue, since it > performs no textual operations whatsoever. It'd be interesting to > modify pgbench so that it updates the "

Re: [HACKERS] multibyte performance

2001-09-28 Thread Tatsuo Ishii
> pgbench unfortunately seems quite irrelevant to this issue, since it > performs no textual operations whatsoever. Yup. > It'd be interesting to > modify pgbench so that it updates the "filler" column somehow on each > update (perhaps store a text copy of the new balance there), and then > rep

Re: [HACKERS] multibyte performance

2001-09-27 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > I did some benchmarking with/without multibyte support using current. > (1) regression test > (2) pgbench pgbench unfortunately seems quite irrelevant to this issue, since it performs no textual operations whatsoever. It'd be interesting to modify pgben

Re: [HACKERS] multibyte performance

2001-09-27 Thread Tatsuo Ishii
> > 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

Re: [HACKERS] multibyte performance

2001-09-27 Thread Hannu Krosing
Tatsuo Ishii wrote: > > I did some benchmarking with/without multibyte support using current. ... > (2) pgbench > > 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.28

Re: [HACKERS] multibyte performance

2001-09-27 Thread Tatsuo Ishii
> It's nice. :-) > Can you try it for old 7.1? I should like see some improvement between > release:-) Not sure if it's meaningfull since new regression test cases might be added for current? -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if p

Re: [HACKERS] multibyte performance

2001-09-27 Thread Karel Zak
On Thu, Sep 27, 2001 at 02:22:07PM +0900, Tatsuo Ishii wrote: > I did some benchmarking with/without multibyte support using current. > > (1) regression test > > With multibyte support: > 9.52user 3.38system 0:59.27elapsed 21%CPU (0avgtext+0avgdata 0maxresident)k > > Without multibyte support:

[HACKERS] multibyte performance

2001-09-26 Thread Tatsuo Ishii
I did some benchmarking with/without multibyte support using current. (1) regression test With multibyte support: 9.52user 3.38system 0:59.27elapsed 21%CPU (0avgtext+0avgdata 0maxresident)k Without multibyte support: 8.97user 4.84system 1:00.85elapsed 22%CPU (0avgtext+0avgdata 0maxresident)k