From: | Jim Thomason <thomasoniii(at)gmail(dot)com> |
---|---|
To: | psql-performance(at)postgresql(dot)org |
Subject: | performance with column orders |
Date: | 2004-08-05 18:10:01 |
Message-ID: | 5cfdfaf7040805111013a769af@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I couldn't track down recent info in the archives, so I figured I'd ask here.
Does the order of columns still have an impact on table speed? Back in
the olden days, it used to be that fixed width columns (integer,
tinyint, etc.) should be the first ("left") columns in the table and
variable width ones should be towards the end ("right"). This allowed
a database to line up the columns better on disk and give you a speed
boost.
So, does Postgres still care about it? And, if so, how much? The posts
I found were from 2 years ago, and indicated that there is a minor
increase, but not a lot. Incidentally, could anyone quantify that in
any fashion?
Thanks,
-Jim....
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-08-06 04:46:14 | Re: pg_dump performance? |
Previous Message | Gaetano Mendola | 2004-08-05 15:41:13 | Re: Temporary tables |