3 ms·
Are you looking for something similar to flag -j, --jobs of http://www.postgresql.org/docs/8.4/static/app-pgrestore.html http://www.postgresql.org/docs/8.4/stat
by random42 15y ago
Are you looking for something similar to flag -j, --jobs of http://www.postgresql.org/docs/8.4/static/app-pgrestore.html http://www.postgresql.org/docs/8.4/static/app-pgrestore.html, which implies the number of jobs running in parallel (which to my understanding depends on the number of CPU cores.)
Granted, this only exists for pg_restore (8.4 onwards), no equivalent functionality in postgres for pg_dump.
- wiredfool 15y agoSomething like that. The nice thing there is that the index creation is done in parallel, which is not split well with my method. What I do is dump the schema, then split it between the table creation and the indexes. The first part gets loaded before the data, the second, after. Then all the tables and all the sequences are dumped, optionally teed to disk, and loaded in a psql process to the new location. I've been doing this since the 7.x series, so it way predates 8.4. (It also predates the in place upgrades, which is a big thing that they've added since I was coming up to speed)