X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C62A3D1BB5E for ; Tue, 18 Nov 2003 19:29:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 91975-10 for ; Tue, 18 Nov 2003 15:29:26 -0400 (AST) Received: from b0x.supernerd.com (unknown [208.186.134.90]) by svr1.postgresql.org (Postfix) with ESMTP id D1F0FD1B8B6 for ; Tue, 18 Nov 2003 15:29:24 -0400 (AST) Received: from trogdor (unknown [67.42.122.198]) by b0x.supernerd.com (Postfix) with ESMTP id 1580E5FD1B; Tue, 18 Nov 2003 12:25:34 -0700 (MST) Message-ID: <019f01c3ae0a$46bd1a50$0700a8c0@trogdor> From: "Rick Gigger" To: "Keith C. Perry" Cc: "PgSQL General ML" References: <1069164075.986.239.camel@bbking.uio.no> <20031118142919.GI4953@libertyrms.info> <1069180780.2769.91.camel@haggis.homelan> <019301c3ae07$d714e220$0700a8c0@trogdor> <1069183501.3fba720d48aba@webmail.vcsn.com> Subject: Re: uploading files Date: Tue, 18 Nov 2003 12:29:24 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/937 X-Sequence-Number: 52587 I will search the archives but does anyone know off the top of their head which performs better? ----- Original Message ----- From: "Keith C. Perry" To: "Rick Gigger" Cc: "PgSQL General ML" Sent: Tuesday, November 18, 2003 12:25 PM Subject: Re: [GENERAL] uploading files > Quoting Rick Gigger : > > > What is the best method for storing files in postgres? Is it better to use > > the large object functions or to just encode the data and store it in a > > regular text or data field? > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > Rick, > > This has been discussed recently so you might want to dig through the archives > but one thing to be aware of is that with large objects, you have have to dump > your database in a different format- a non-text format. This is less portable > than storing files as bytea's which can be dumped in the text and non-text > formats. Argueably is all you use is PosgreSQL then this might not be a big deal. > > Performance-wise I'm not qualified to speak to which is "better". As always, it > is going to depend on your specific application and environment. > > -- > Keith C. Perry, MS E.E. > Director of Networks & Applications > VCSN, Inc. > http://vcsn.com > > ____________________________________ > This email account is being host by: > VCSN, Inc : http://vcsn.com >