TOAST & performance with lots of big columns in a table

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: TOAST & performance with lots of big columns in a table
Date: 2000-12-13 16:34:47
Message-ID: 3A37A527.86511464@joerdens.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 sync. What I am wondering is:

From a conceptual point of view, it appears better to keep all translations in one table.
I forget what exactly the argument is; it has something to do with normalization theory.
Anyway I've already got meta information about articles that applies to all translations -
such as author, position within the overall structure, related articles etc.; so if I were
to have a table for every language, then every article row in any language-table
corresponding to a particular article would have to link with the same row in authors,
index, etc., and the structure would get more complicated than it needs to be. However,
with a long article of maybe several 100 K, and translations in 6 languages (this is
theoretical, actually I have only 2 at the moment), the row size would increase
accordingly. Does this pose a problem for TOAST? Is it a better plan to have a separate
table for each language?

- Frank

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-13 16:45:15 Re: Problem with pg_hba.conf
Previous Message Schmidt, Peter 2000-12-13 16:30:31 RE: Postgres failover implementation