From: | Egon Sommer <Service(at)Sommer-Maschinenbau(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Performance of column order |
Date: | 2002-04-18 07:57:28 |
Message-ID: | 200204180752.JAA06553@post.webmailer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hallo!
Do anybody know if the order of the columns in a table has affect on the performance?
Should I use length-variable colums like TEXT, BLOB,... alfter length-static colums like INTEGER, BOOLEAN, ...?
Is there a advantage to create a separate table for BLOBS and TEXT joining the main table about a primary key?
Thanks for help
Jörg Sommer
--------------------------------------------------------------------------
Sommer Maschinenbau
Pagenstecherstr. 146
49090 Osnabrück
0049 (0)541 125085
0049 (0)541 129557
Service(at)Sommer-Maschinenbau(dot)de
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Petr Bravenec | 2002-04-18 08:05:52 | Re: SQL question.. |
Previous Message | Lee Kindness | 2002-04-18 07:46:33 | determining database size |