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 9A0EF11F6AE3 for ; Tue, 11 Apr 2006 23:05:30 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.439 X-Spam-Level: X-Spam-Status: No, score=0.439 required=5 tests=[AWL=0.439] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id MhPoTfk8okIW for ; Tue, 11 Apr 2006 23:05:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from houston.familyhealth.com.au (houston.au.fhnetwork.com [203.22.197.21]) by postgresql.org (Postfix) with ESMTP id 1CC4811F6AE0 for ; Tue, 11 Apr 2006 23:05:24 -0300 (ADT) Received: from houston.familyhealth.com.au (localhost [127.0.0.1]) by houston.familyhealth.com.au (Postfix) with ESMTP id 4766025073; Wed, 12 Apr 2006 10:05:24 +0800 (WST) Received: from [127.0.0.1] (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (Postfix) with ESMTP id EC0712506F; Wed, 12 Apr 2006 10:05:20 +0800 (WST) Message-ID: <443C60B9.3080705@calorieking.com> Date: Wed, 12 Apr 2006 10:06:49 +0800 From: Christopher Kings-Lynne User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Jesper Krogh Cc: Vivek Khera , Postgresql Performance Subject: Re: Restore performance? References: <810F9DD5-22B1-4A6F-B76C-D7EA7B89035B@khera.org> <38326.195.41.66.226.1144757097.squirrel@mail.jabbernet.dk> In-Reply-To: <38326.195.41.66.226.1144757097.squirrel@mail.jabbernet.dk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-familyhealth-MailScanner-Information: Please contact the ISP for more information X-familyhealth-MailScanner: Found to be clean X-familyhealth-MailScanner-From: chris.kings-lynne@calorieking.com X-Archive-Number: 200604/255 X-Sequence-Number: 18339 >> Well, your pg_dump command lost your BLOBs since the plain text >> format doesn't support them. > > Well, no.. they are stored as BYTEA not Large Objects.. They are encoded > in ASCII in the pg_dump output. As a side note: plain text dump format in 8.1 supprts LOBs