I have a large text corpus that I am storing in Postgres. A table
articles has all of the metadata for each article, about 19 million rows. It's primary key is
articles.doc_id. Another table (
texts) stores the texts themselves, with a text column for the document text, and a column
texts.doc_id which is a primary key that is also a foreign key to
Is this the best way to store a large amount of text, or would I better off just having a another column on the
articles table with the text?