Re: Restore performance?

From: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
To: Jesper Krogh <jesper(at)krogh(dot)cc>
Cc: Vivek Khera <vivek(at)khera(dot)org>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Restore performance?
Date: 2006-04-12 02:06:49
Message-ID: 443C60B9.3080705@calorieking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-12 02:56:43 Re: FOREIGN KEYS vs PERFORMANCE
Previous Message Jim C. Nasby 2006-04-11 23:38:20 Re: FOREIGN KEYS vs PERFORMANCE