Egon Sommer <Service(at)Sommer-Maschinenbau(dot)de> writes:
> Should I use length-variable colums like TEXT, BLOB,... alfter length-static colums like INTEGER, BOOLEAN, ...?
There is some marginal advantage to that, but I wouldn't recommend
contorting your application to do it. In particular, AFAIR it only
helps in a row that has no NULLs. (Check the heap_getattr code for
the gory details.)
> Is there a advantage to create a separate table for BLOBS and TEXT joining the main table about a primary key?
No ... TOAST more or less does that for you.
regards, tom lane