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
Jesper Krogh wrote:
Hi
I'm currently upgrading a Posgresql 7.3.2 database to a
8.1.something-good
I'd run pg_dump | gzip sqldump.gz on the old system. That took about
30 hours and gave me an 90GB zipped file. Running
cat sqldump.gz | gunzip | psql
into the 8.1 database seems to take about
If they both took the same amount of time, then you are almost certainly
bottlenecked on gzip.
Try a faster CPU or use gzip -fast.
gzip does not seem to be the bottleneck, on restore is psql the nr. 1
consumer on cpu-time.
Jesper
Sorry for the double post.
--
Jesper Krogh
I'd run pg_dump | gzip sqldump.gz on the old system. That took about
30 hours and gave me an 90GB zipped file. Running
cat sqldump.gz | gunzip | psql
into the 8.1 database seems to take about the same time. Are there
any tricks I can use to speed this dump+restore process up?
The
Jesper Krogh [EMAIL PROTECTED] writes:
gzip does not seem to be the bottleneck, on restore is psql the nr. 1
consumer on cpu-time.
Hm. We've seen some situations where readline mistakenly decides that
the input is interactive and wastes lots of cycles doing useless
processing (like keeping
On 4/10/06, Jesper Krogh [EMAIL PROTECTED] wrote:
HiI'm currently upgrading a Posgresql 7.3.2 database to a8.1.something-goodI'd run pg_dump | gzip sqldump.gzon the old system. That took about30 hours and gave me an 90GB zipped file. Running
cat sqldump.gz | gunzip | psqlinto the 8.1 database
sorry for the post , i didn' saw the other replies only after posting.On 4/10/06, Rajesh Kumar Mallah [EMAIL PROTECTED]
wrote:
On 4/10/06, Jesper Krogh [EMAIL PROTECTED]
wrote:
HiI'm currently upgrading a Posgresql 7.3.2 database to a8.1.something-goodI'd run pg_dump | gzip sqldump.gzon the old
4. fsync can also be turned off while loading huge dataset , but seek others comments too (as study docs) as i am not sure about the reliability. i think it can make a lot of difference.
On 4/10/06, Jesper Krogh [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah wrote: I'd run pg_dump | gzip
Rajesh Kumar Mallah wrote:
4. fsync can also be turned off while loading huge dataset ,
but seek others comments too (as study docs) as i am not sure about the
reliability. i think it can make a lot of difference.
Also be sure to increase maintenance_work_mem so that index creation
On Apr 10, 2006, at 3:55 AM, Jesper Krogh wrote:
I'd run pg_dump | gzip sqldump.gz on the old system. That took
about
30 hours and gave me an 90GB zipped file. Running
cat sqldump.gz | gunzip | psql
into the 8.1 database seems to take about the same time. Are there
any tricks I can use to
10 matches
Mail list logo