| From: | "Pierre C" <lists(at)peufeu(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org, "Tony Capobianco" <tcapobianco(at)prospectiv(dot)com> |
| Subject: | Re: oracle to psql migration - slow query in postgres |
| Date: | 2010-10-14 22:50:20 |
| Message-ID: | op.vkk8d6rpeorkce@apollo13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shoaib Mir | 2010-10-14 22:53:00 | Re: How to find the primary server of a hot standby server? |
| Previous Message | Guillaume Lelarge | 2010-10-14 22:39:51 | Re: How to find the primary server of a hot standby server? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2010-10-15 03:59:14 | Re: oracle to psql migration - slow query in postgres |
| Previous Message | Cédric Villemain | 2010-10-14 21:25:41 | Re: oracle to psql migration - slow query in postgres |