pg_dump slower than pg_restore

Поиск
Список
Период
Сортировка
Искать
От
David Wall
Тема
pg_dump slower than pg_restore
Дата
Msg-id
53B58D0C.1000203@computer.org
Список
Дерево обсуждения
pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Eduardo Morras <emorrasg@yahoo.es>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Bosco Rama <postgres@boscorama.com>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Bosco Rama <postgres@boscorama.com>
Re: pg_dump slower than pg_restore Bosco Rama <postgres@boscorama.com>
Re: pg_dump slower than pg_restore Tim Clarke <tim.clarke@manifest.co.uk>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore John R Pierce <pierce@hogranch.com>
Re: pg_dump slower than pg_restore Bosco Rama <postgres@boscorama.com>
Re: pg_dump slower than pg_restore Bosco Rama <postgres@boscorama.com>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Bosco Rama <postgres@boscorama.com>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Bosco Rama <postgres@boscorama.com>
Re: pg_dump slower than pg_restore David Wall <d.wall@computer.org>
Re: pg_dump slower than pg_restore Steve Kehlet <steve.kehlet@gmail.com>
Re: pg_dump slower than pg_restore Jacob Bunk Nielsen <jacob@bunk.cc>
I'm running PG 9.3.4 on CentOS 6.4 and noted that backing up my database 
takes much longer than restoring it.

That seems counter-intuitive to me because it seems like reading from a 
database should generally be faster than writing to it.

I have a database that pg_database_size reports as 18GB, and resulting 
dump is about 13GB in 27 files (split creates them as 512MB).

A pg_dump backup -- with most of the data stored as large objects -- 
takes about 5 hours.

But restoring that dump takes about 2 hours.  So it's taking 2.5 times 
longer to back it up than to restore it.

My backup script runs vacuumlo, then vacuum, then analyze, then pg_dump 
--format=c --oids $DB

I actually push pg_dump output through gzip, gpg and split on 512MB 
files, but they shouldn't matter too much I figure as I have to run cat, 
gpg and gunzip before pg_restore.  In fact, my restore should have been 
at a disadvantage because I used '-v' and showed the results to my ssh 
term over the Internet which includes a line for each LOID, and the 
postgresql.conf had 'ddl' logging on (which I suspect I can turn off in 
future restores to speed things up a bit).

Is there something that might be wrong about my configuration that the 
backup is slower than the restore?

Thanks,
David


В списке pgsql-general по дате отправления
От: sunpeng
Дата:
От: Bosco Rama
Дата:
FAQ