Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CA1769F9F2F for ; Sun, 4 Feb 2007 17:48:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 74131-04 for ; Sun, 4 Feb 2007 17:48:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from server.firetrust.net (mailserver.firetrust.com [209.213.221.13]) by postgresql.org (Postfix) with ESMTP id C84AE9F9EF0 for ; Sun, 4 Feb 2007 17:48:36 -0400 (AST) Received: from localhost.localdomain (203-97-61-135.dsl.clear.net.nz [203.97.61.135]) by server.firetrust.net (8.13.8/8.13.8) with SMTP id l14LmWrf020136 for ; Mon, 5 Feb 2007 10:48:34 +1300 Date: Mon, 5 Feb 2007 10:48:29 +1300 From: Steve Holdoway To: pgsql-admin@postgresql.org Subject: Re: blobs Message-Id: <20070205104829.1cea225a.steve.holdoway@firetrust.com> In-Reply-To: <81961ff50702012004m3aeff4d9k2193917682314fb@mail.gmail.com> References: <20070201104606.5ea9e44e.steve.holdoway@firetrust.com> <81961ff50701311545h50e457c4scb108037d6cf5c16@mail.gmail.com> <20070202073937.b80f6ccc.steve.holdoway@firetrust.com> <81961ff50702012004m3aeff4d9k2193917682314fb@mail.gmail.com> Organization: Firetrust Ltd X-Mailer: Sylpheed version 2.3.0beta5 (GTK+ 2.8.20; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.90rc3, clamav-milter version devel-170107 on server.firetrust.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.171 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/50 X-Sequence-Number: 24515 On Thu, 1 Feb 2007 23:04:57 -0500 "Chad Wagner" wrote: > I have plenty of experience building large distributed OLTP systems and > multi terabyte data warehouses, so you can either take the advice or leave > it. > Me too, since Oracle 6, Informix and Ingres in the late 80's until today. What I don't have experience of, and what you omitted from this informative post are expeciences of postgres 8.x's handling of blobs - the question I asked - rather than the effect of using text columns which is a different question altogether. Steve