| 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: | Whole Thread | Raw Message | 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 |