Re: Restore performance? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Restore performance?
Date
Msg-id 443C60B9.3080705@calorieking.com
Whole thread Raw
In response to Re: Restore performance?  ("Jesper Krogh" <jesper@krogh.cc>)
List pgsql-performance
>> 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


pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: FOREIGN KEYS vs PERFORMANCE
Next
From: Tom Lane
Date:
Subject: Re: FOREIGN KEYS vs PERFORMANCE