From: Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
To: Jesper Krogh <jesper@krogh.cc>
Cc: Vivek Khera <vivek@khera.org>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Restore performance?
Date: Wed, 12 Apr 2006 10:06:49 +0800
Message-ID: <443C60B9.3080705@calorieking.com> (raw)
In-Reply-To: <38326.195.41.66.226.1144757097.squirrel@mail.jabbernet.dk>
References: <e1d31l$2nt$1@sea.gmane.org>
<810F9DD5-22B1-4A6F-B76C-D7EA7B89035B@khera.org>
<38326.195.41.66.226.1144757097.squirrel@mail.jabbernet.dk>
>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: chris.kings-lynne@calorieking.com, jesper@krogh.cc, vivek@khera.org
Subject: Re: Restore performance?
In-Reply-To: <443C60B9.3080705@calorieking.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox