Re: Real vs Int performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Greco <David_Greco(at)harte-hanks(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Real vs Int performance
Date: 2011-01-27 14:18:11
Message-ID: 21353.1296137891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

David Greco <David_Greco(at)harte-hanks(dot)com> writes:
> Right you are. Kettle is turning the number(11) field from Oracle into
> a BigNumber, which is a decimal. If I cast the field into an Integer
> in Kettle and keep the field an integer in Postgres, I get good
> performance. Suspect the correct course of action would simply be to
> make number(11) fields in Oracle numeric(11,0) fields in Postgres.

Not if you can persuade the client-side code to output integers as
integers. "numeric" type is orders of magnitude slower than integers.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2011-01-27 14:30:15 Re: Real vs Int performance
Previous Message Shaun Thomas 2011-01-27 14:17:23 Re: Why I lost the last pg_xlog file?