S
S
Sergey Alekseev2019-01-19 12:49:29
PostgreSQL
Sergey Alekseev, 2019-01-19 12:49:29

Postgres, why is pg_dumpall faster than pg_dump?

Usually I did a dump using pg_dump, it took about 25 minutes.
I decided to make a dump using pg_dumpall, it took about 7 minutes.
Why such a difference?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Boris Korobkov, 2019-01-19
@BorisKorobkov

https://www.postgresql.org/docs/9.2/app-pg-dumpall.html
pg_dumpall calls pg_dump in a loop, so there's no way it can be faster. You just have a measurement error: due to locks, caching, etc.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question