| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Lockhart <lockhart(at)fourpalms(dot)org>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: FUNC_MAX_ARGS benchmarks |
| Date: | 2002-08-06 21:25:40 |
| Message-ID: | 3D503ED4.3050608@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Peter Eisentraut wrote:
> Joe Conway writes:
>>Here's the multi-user test summary. Very little difference. The details
>>of the OSDB output are attached.
>
> The fact that the OSDB benchmark has just about the least possible test
> coverage of identifier handling and you still get a 2% performance drop is
> something I'm concerned about.
>
Of course that's on the single user test only. In the multi-user test
the two are neck-and-neck. If you really want to be concerned, see the
attached. This lines up results from:
REL7_2_STABLE with NAMEDATALEN = 32 and FUNC_MAX_ARGS = 16
7.3devel with NAMEDATALEN = 32 and FUNC_MAX_ARGS = 32
7.3devel with NAMEDATALEN = 128 and FUNC_MAX_ARGS = 32
In the single-user test, REL7_2_STABLE is best by about 10%. But in the
multi-user test (10 users), *both* 7.3devel tests are about 3.5% faster
than 7.2.
Joe
| Attachment | Content-Type | Size |
|---|---|---|
| OSDB-comp.pdf | application/pdf | 6.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | qdeng | 2002-08-06 21:35:41 | How the |
| Previous Message | Peter Eisentraut | 2002-08-06 21:18:18 | Re: SQL99 CONVERT() function |