BUG #12675: BIGINT Datatype performance
| От | derek.anderson@mspmac.org |
|---|---|
| Тема | BUG #12675: BIGINT Datatype performance |
| Дата | |
| Msg-id | 20150126210437.19767.89672@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #12675: BIGINT Datatype performance
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 12675 Logged by: Derek Anderson Email address: derek.anderson@mspmac.org PostgreSQL version: 9.4.0 Operating system: Linux Description: I did some testing on bigint vs double precision datatype performance for a project we have going on here. To my surprise, I found the double precision (floating) was well over 200% faster than bigint in aggregate functions. I don't know if this qualifies as a bug, but it sure seems odd considering non-floating type datatypes usually perform much faster than floating. Please contact me if you wish to discuss. -Derek Derek Anderson 612.293.8515 Metropolitan Airports Commission derek.anderson@mspmac.org
В списке pgsql-bugs по дате отправления: