From: Pierre C <lists@peufeu.com>
To: pgsql-performance@postgresql.org, "Tony Capobianco" <tcapobianco@prospectiv.com>
Subject: Re: oracle to psql migration - slow query in postgres
Date: Fri, 15 Oct 2010 00:50:20 +0200
Message-ID: <op.vkk8d6rpeorkce@apollo13> (raw)
In-Reply-To: <1287085384.1684.52.camel@tony1.localdomain>
References: <1287085384.1684.52.camel@tony1.localdomain>
> emailok | numeric(2,0) |
Note that NUMERIC is meant for
- really large numbers with lots of digits
- or controlled precision and rounding (ie, order total isn't
99.999999999999 $)
Accordingly, NUMERIC is a lot slower in all operations, and uses a lot
more space, than all the other numeric types.
I see many columns in your table that are declared as NUMERIC but should
be BOOLs, or SMALLINTs, or INTs, or BIGINTs.
Perhaps Oracle handles these differently, I dunno.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@peufeu.com, tcapobianco@prospectiv.com
Subject: Re: oracle to psql migration - slow query in postgres
In-Reply-To: <op.vkk8d6rpeorkce@apollo13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox