Received: from trade-india.com (mail.trade-india.com [130.94.20.28] (may be forged)) by postgresql.org (8.11.3/8.11.4) with SMTP id g1C5aJE33859 for ; Tue, 12 Feb 2002 00:36:19 -0500 (EST) (envelope-from mallah@trade-india.com) Received: (qmail 23984 invoked from network); 12 Feb 2002 05:39:33 -0000 Received: from ptil-235-129-del.primus-india.net (HELO trade-india.com) (203.196.129.235) by 130.94.22.209 with SMTP; 12 Feb 2002 05:39:33 -0000 Message-ID: <3C68AA95.38EE467C@trade-india.com> Date: Tue, 12 Feb 2002 11:09:33 +0530 From: mallah@trade-india.com X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Storing text data in databases. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/124 X-Sequence-Number: 6552 Hi folks, Is it a good idea to store large amount of text ( ~ 5-10 K ) in database columns from performance point of view? or store the text in sperate files and store the id of the file in the databases. Mallah.