Search Postgresql Archives

Re: trouble with upgrade from 9.0 (many schemas and tables)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




30.01.2013, 18:47, "Jeff Janes" <jeff.janes@xxxxxxxxx>:
> On Tue, Jan 29, 2013 at 9:23 PM, Groshev Andrey <greenx@xxxxxxxxx> wrote:
>
>>  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.
>
> Are the schemas all about the same size (in number of tables)?

Yes, 130 tables, 120 triggers, 700 functions. 
Only some schemas different from them.

> There are several places in the code which are quadratic in the number
> of tables being dumped and restored.  There have been many fixes
> recently in 9.2 and especially (future) 9.3, but unfortunately you
> have to upgrade in order to get those benefits.
>
>>  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"
>
> Was it exactly that, or was it about shared memory for holding locks?
> ...

Unfortunately, I can't say anything about memory problems.
This post was my colleague.
In my attempt to not wait ... but I waited 17 hours.

>>  The only thing that came up while doing a dump on each schema.
>>  But will it be the right approach?
>
> Unfortunately, that might be your best option to get around the
> quadratic behavior.

Yes, some string in shell script. 
Before me, this problem is solved as well.

> You would probably want to use the pg_dump from 9.2, as there are
> improvements in that version of pg_dump to speed up partial dumps.
> You can use pg_dump from 9.2  against server 9.0 and still get the
> improvements.  But that means you should be upgrading to 9.2 rather
> than 9.1.  (Which you should probably do anyway unless you have a
> specific reason not to.)
>
> Cheers,
>
> Jeff

Now think about it. Try to make 9.0 -> 9.2 -> 9.1 ?

Thank you!



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux