|
Hi, > You can then > pull a TOC out with pg_restore and break that appart. Reading the TOC is > pretty self evident. Once you get down to index creation you can create > multiple files each with a group of indexes to create. Then call > pg_restore multiple times in a script against the individual TOC and you > will use all cores. I figured something like this would be possible. Thanks for the explanation. Ultimately I'm looking for something more automatic though. Not that I personally mind doing the above, but when an emergency restore is needed for some production server manually editing a dump is probably not the safest course of action ;) It sounds like something though that a tool could do automatically. The mentioned patch sounds interesting too, is there anything known about whether this patch will make it into the main stream Postgres source? I guess it's too late for inclusion in PostgreSQL 8.4, but 8.5 perhaps? Kind regards What can you do with the new Windows Live? Find out |
