X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8DF0D474E42 for ; Mon, 28 Apr 2003 01:00:19 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 40D7C475956 for ; Mon, 28 Apr 2003 01:00:08 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3S501U6011755; Mon, 28 Apr 2003 01:00:01 -0400 (EDT) To: jeremy@jeremya.com Cc: pgsql-performance@postgresql.org Subject: Re: pgsql BLOB issues In-reply-to: <200304272230.23583@jeremy-rokks> References: <200304272230.23583@jeremy-rokks> Comments: In-reply-to Jeremy Andrus message dated "Sun, 27 Apr 2003 22:30:23 -0400" Date: Mon, 28 Apr 2003 01:00:01 -0400 Message-ID: <11754.1051506001@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/222 X-Sequence-Number: 1728 Jeremy Andrus writes: > I have a database that contains a large amount of Large Objects > (>500MB). I am using this database to store images for an e-commerce > website, so I have a simple accessor script written in perl to dump out > a blob based on a virtual 'path' stored in a table (and associated with > the large object's OID). This system seemed to work wonderfully until I > put more than ~500MB of binary data into the database. Are you talking about 500MB in one BLOB, or 500MB total? If the former, I can well imagine swap thrashing being a problem when you try to access such a large blob. If the latter, I can't think of any reason for total blob storage to cause any big performance issue. Perhaps you just haven't vacuumed pg_largeobject in a long time? regards, tom lane