| From: | Mark Butler <butlerm(at)middle(dot)net> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: New benchmark result |
| Date: | 2001-04-13 23:47:12 |
| Message-ID: | 3AD79000.B4AEE528@middle.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Mark Butler wrote:
> I did several tests with functions designed to sum the number 12345 a million
> times. The results are as follows (Pentium II 450, Redhat 6.2):
>
> Postgres PL/PGSQL original numeric: 14.8 seconds
> Postgres PL/PGSQL modified numeric: 11.0 seconds
> Postgres PL/PGSQL float8: 10.7 seconds
> GNU AWK: 2.5 seconds
> Oracle PL/SQL number: 2.0 seconds
I have a new result:
Postgres PL/PGSQL integer: 7.5 seconds
I do not know what to attribute the large difference between float8 and int to
other than pg_alloc overhead used in the calling convention for float8.
Commments?
- Mark Butler
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-04-13 23:50:08 | Re: cvs postgres doesn't compile with libreadline 4.2 |
| Previous Message | Nathan Myers | 2001-04-13 23:37:32 | Re: Anyone have any good addresses ... ? |