pg_upgrade on high number tables database issues

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема pg_upgrade on high number tables database issues
Дата
Msg-id CAFj8pRAv_hr5BoPjogg_dD=D_iHjK3KJCA4DgMh+uZnVzBzn7w@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_upgrade on high number tables database issues  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
Hello

I had to migrate our databases from 9.1 to 9.2. We have high number of databases per cluster (more than 1000) and high number of tables (indexes) per database (sometimes more than 10K, exceptionally more than 100K).

I seen two problems:

a) too long files pg_upgrade_dump_db.sql, pg_upgrade_dump_all.sql in postgres HOME directory. Is not possible to change a directory for these files.

b) very slow first stage of upgrade - schema export is very slow without high IO or CPU utilization.

Regards

Pavel

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Standby node using replication slot not visible in pg_stat_replication while catching up
Следующее
От: Robert Haas
Дата:
Сообщение: Re: on_exit_reset fails to clear DSM-related exit actions