Re: [GENERAL] TOAST & performance with lots of big columns in a table

2000-12-13 Thread Frank Joerdens
Uh, I think I was wired rather the wrong way up, this question is confused. What a little fresh air can do. Cycling home from the office cleared the confusion in my head: It is of course nonsense to store all translations in a single row, also to have different tables for different languages. You

[GENERAL] TOAST & performance with lots of big columns in a table

2000-12-13 Thread Frank Joerdens
I've got an articles table where I want to store texts, of which several translations exist. Thanks to TOAST I can now store texts of arbitrary length directly in the table, which is already a big advantage over stuffing them into the file system and trying to keep the database and file system in