From: | Jon Lapham <lapham(at)jandr(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, CSN <cool_screen_name90001(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: How much slower are numerics? |
Date: | 2005-10-22 13:57:42 |
Message-ID: | 435A4556.7020606@jandr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
> On modern hardware, I'd expect float operations to be at least an order
> of magnitude faster than numerics
> [snip]
> regression$# declare x float8 := 0;
> regression=# select timeit(1000000);
> Time: 13700.960 ms
> [snip]
> regression$# declare x numeric := 0;
> regression=# select timeit(1000000);
> Time: 22145.408 ms
But, this is less than a factor of 2 difference, similar to what one of
the previous INSERT examples showed. Or am I missing something?
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham <lapham(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Gibson (DB Administrator) | 2005-10-22 15:16:48 | Re: Blank-padding |
Previous Message | Andreas Kretschmer | 2005-10-22 13:36:10 | Re: pg_dump with low priority? |