> 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. > But once you use the -Fc format on your dump and enable blob backups, > you can speed up reloads by increasing your checkpoint segments to a big > number like 256 and the checkpoint timeout to something like 10 minutes. > All other normal tuning parameters should be what you plan > to use for your normal operations, too. Thanks. Jesper -- Jesper Krogh ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
