Re: BUG #7884: pg_upgradecluster is terribly slow - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #7884: pg_upgradecluster is terribly slow
Date
Msg-id 1360952867.24218.YahooMailNeo@web162903.mail.bf1.yahoo.com
Whole thread Raw
In response to BUG #7884: pg_upgradecluster is terribly slow  (rtvd@me.com)
Responses Re: BUG #7884: pg_upgradecluster is terribly slow
List 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 by date:

Previous
From: rtvd@me.com
Date:
Subject: BUG #7884: pg_upgradecluster is terribly slow
Next
From: Martin Pitt
Date:
Subject: Re: BUG #7884: pg_upgradecluster is terribly slow