X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EB2FB9DCA67 for ; Mon, 27 Mar 2006 16:16:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71413-02 for ; Mon, 27 Mar 2006 16:16:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from pproxy.gmail.com (pproxy.gmail.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id DDCF09DC99C for ; Mon, 27 Mar 2006 16:16:20 -0400 (AST) Received: by pproxy.gmail.com with SMTP id m51so150619pye for ; Mon, 27 Mar 2006 12:16:19 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=mcdRrhF99WmIOBRYat+Pvaf/iIPVbcJRt6DtvA9TqOV+OsMqgHz+eZ0I+FrUucv3JcE4nvQ2S8e7jLhXAMbvgCtvmVjLknZgVyB1+A12fbpuOeoO+BDsykXY3/Gp/ZZm8+Jk3m6vDzg9NkB8Ka9rmlTSzWZeixqEsOZ87VuUicQ= Received: by 10.65.156.11 with SMTP id i11mr2726805qbo; Mon, 27 Mar 2006 12:16:18 -0800 (PST) Received: by 10.65.240.20 with HTTP; Mon, 27 Mar 2006 12:16:18 -0800 (PST) Message-ID: <3cf983d0603271216x6d4a4614ye6dc48e31e8b5cb6@mail.gmail.com> Date: Mon, 27 Mar 2006 12:16:18 -0800 From: "Rodrigo Madera" To: pgsql-performance@postgresql.org Subject: Large Binary Objects Middleware MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.726 required=5 tests=[AWL=-0.606, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 0.726 X-Spam-Level: X-Archive-Number: 200603/532 X-Sequence-Number: 17969 Hello to all on the list. I have developed a product that sits between the database and an application that handles the storage of large binary data. The system is fast, but I'm feeling bad as to think that I have completely reinvented the weel on this case. You see, the engine does just stores the large data in "containers" that are directly on the filesystem instead of going to the database directly (since some of this list's members told me it would make the database really slow to store the data directly). So now I have a huge dilema as to continue this reinvention or use direct large objects. The database is holding large ammounts of digital video, and I am wanting to put these directly into the database. What performance guidelines would you all give seeing my position today? Thanks for all your speed-up tips, Rodrigo