Re: BUG #7884: pg_upgradecluster is terribly slow
От | Kevin Grittner |
---|---|
Тема | Re: BUG #7884: pg_upgradecluster is terribly slow |
Дата | |
Msg-id | 1360952867.24218.YahooMailNeo@web162903.mail.bf1.yahoo.com обсуждение исходный текст |
Ответ на | BUG #7884: pg_upgradecluster is terribly slow (rtvd@me.com) |
Ответы |
Re: BUG #7884: pg_upgradecluster is terribly slow
|
Список | pgsql-bugs |
"rtvd@me.com" <rtvd@me.com> wrote:=0A=0A> I have tried upgrading a database= from 8.4 to 9.1 and=0A> pg_upgradecluster is terribly slow.=0A=0AI had nev= er heard of pg_upgradecluster sluster; a google search=0Asuggests that ther= e is an Ubuntu utility by that name, so you might=0Awant to register a comp= laint there; this list is definitely not the=0Aright place for that.=0A=0AY= ou might want to try the utility which *is* supported by the=0APostgreSQL c= ommunity, which is pg_upgrade.=A0 For speed, consider=0Ausing the -k option= .=A0 I've been able to upgrade a 3 TB database in=0Ajust a few minutes with= that.=A0 (Timing depends more on the number=0Aof database objects than the= ir size.)=0A=0Ahttp://www.postgresql.org/docs/9.1/interactive/pgupgrade.htm= l=0A=0A-- =0AKevin Grittner=0AEnterpriseDB: http://www.enterprisedb.com=0AT= he Enterprise PostgreSQL Company
В списке pgsql-bugs по дате отправления: