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 5A1D6D1B4EF for ; Tue, 18 Nov 2003 19:37:48 +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 96657-09 for ; Tue, 18 Nov 2003 15:37:18 -0400 (AST) Received: from asmodeus.mcnaught.org (sp-260-1.net4.netcentrix.net [4.21.254.118]) by svr1.postgresql.org (Postfix) with ESMTP id 6385BD1B591 for ; Tue, 18 Nov 2003 15:37:01 -0400 (AST) Received: from doug by asmodeus.mcnaught.org with local (Exim 3.36 #1) id 1AMBeC-0003MC-00; Tue, 18 Nov 2003 14:36:24 -0500 To: "Rick Gigger" Cc: "Keith C. Perry" , "PgSQL General ML" Subject: Re: uploading files 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> <019f01c3ae0a$46bd1a50$0700a8c0@trogdor> From: Doug McNaught Date: 18 Nov 2003 14:36:24 -0500 In-Reply-To: "Rick Gigger"'s message of "Tue, 18 Nov 2003 12:29:24 -0700" Message-ID: <87islhqxjb.fsf@asmodeus.mcnaught.org> Lines: 13 X-Mailer: Gnus v5.7/Emacs 20.7 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/938 X-Sequence-Number: 52588 "Rick Gigger" writes: > I will search the archives but does anyone know off the top of their head > which performs better? It really depends on what you are trying to do. If you are always fetching the entire file from the database, 'bytea' *might* have a little less overhead, but it's not clearcut. Both of them will be ultimately limited by how fast you can get data off the disk and and pump it through your client connection. -Doug