Groshev Andrey <greenx@xxxxxxxxx> writes: > 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. This isn't very clear. Are you saying that you successfully updated to 9.1 and now you have a pg_dump performance problem you didn't have before? Or are you still on 9.0 and you are just now finding out that you can't pg_dump (that is, you don't have any routine backup policy)? Also, 9.0.what and 9.1.what? We've fixed a number of pg_dump performance issues with huge schemas in the last year or two, but it's impossible to guess whether you have those fixes. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
