From: | Groshev Andrey <greenx(at)yandex(dot)ru> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | trouble with upgrade from 9.0 (many schemas and tables) |
Date: | 2013-01-30 05:23:22 |
Message-ID: | 395151359523402@web6h.yandex.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello!
I update the databases to version 9.1.
Today, faced with a new challenge.
The database itself is not very big 60G, but has ~ 164,000 tables in 1260 schemes.
I tried and pg_upgrade and pg_dumpall and pg_dump.
But they all work very, very long time.
For so long that I do not have patience.
And pg_dump worked for almost a day, gave "out off memory"
(but this experience made a colleague, so vouch for the accuracy can not).
I tried to just dump schemes-only, but also the procedure lasted more than 17 hours and not over .... I ran out of patience.
If I am not mistaken, all of these programs work on approximately the same algorithm.
At the beginning of block all the tables in all schemas, indexes, and so then....
So I do not see a way to significantly speed up the process.
The only thing that came up while doing a dump on each schema.
But will it be the right approach?
Maybe tell me what to do?
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Law | 2013-01-30 06:00:01 | Re: BUG #7493: Postmaster messages unreadable in a Windows console |
Previous Message | News Subsystem | 2013-01-30 04:41:59 |