Performance of column order - Mailing list pgsql-general

From Egon Sommer
Subject Performance of column order
Date
Msg-id 200204180823.KAA15862@post.webmailer.de
Whole thread Raw
Responses Re: Performance of column order  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Performance of column order  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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@Sommer-Maschinenbau.de
--------------------------------------------------------------------------




pgsql-general by date:

Previous
From: Petr Bravenec
Date:
Subject: Re: SQL question..
Next
From: Christian von Kietzell
Date:
Subject: change a column