| From: | Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com> |
|---|---|
| To: | "sthomas(at)peak6(dot)com" <sthomas(at)peak6(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Greco <David_Greco(at)harte-hanks(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Real vs Int performance |
| Date: | 2011-01-27 15:11:12 |
| Message-ID: | 4D418B10.7050008@vmsinfo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 1/27/2011 9:30 AM, Shaun Thomas wrote:
> I'm not sure about orders of magnitude on the storage/index side, but my
> tests gave us a 10% boost if just the keys are switched over to INT or
> BIGINT.
Well, it depends on what you're doing. Searching by an integer vs.
searching by a text string will probably not make much of a difference.
However, if you are calculating sums or averages, there will be a huge
difference.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2011-01-27 15:41:08 | Postgres 9.0 has a bias against indexes |
| Previous Message | Michael Kohl | 2011-01-27 15:09:16 | Re: High load, |