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
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 |