| From: | Fabio Rueda Carrascosa <avances123(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_upgrade link mode |
| Date: | 2013-05-16 17:42:15 |
| Message-ID: | CAA3M-fb28v+gH=qtLNW94VA7Z+yZw8+dSfRAPtX-3+Two+uYLw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello, I have a 9.1 cluster with 50 databases, only one table per db with
2000 rows only, but a lot of schema around each one (postgis databases)
The old cluster size is 1GB
du -chs /var/lib/postgresql/9.1/main/
1.1G
now I run a pg_upgrade to 9.2 with hard link mode,
pg_upgrade --link \
--old-datadir=/var/lib/postgresql/9.1/main \
--new-datadir=/var/lib/postgresql/9.2/main \
--old-bindir=/usr/lib/postgresql/9.1/bin \
--new-bindir=/usr/lib/postgresql/9.2/bin
du -chs /var/lib/postgresql/9.2/main/
880M
Is the expected behaviour? I can't double the space in production.
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JotaComm | 2013-05-16 17:44:18 | Re: WAL contains references to invalid pages |
| Previous Message | Tom Lane | 2013-05-16 17:36:12 | Re: 9.3 beta and materialized views |