[Pkg-postgresql-public] Default PostgreSQL in Etch
Florian Weimer
fw at deneb.enyo.de
Fri Feb 9 18:17:58 CET 2007
* Michelle Konzack:
> Should I force an upgrade to 8.1?
Upgrading to 8.2 would be another option. In a few cases, the
improved planner support for table partitioning is quite handy.
> I have a PostgreSQL Database of nearly 560 GByte and it is not realy
> easy to pg_dump_all this pig and push it back into the 8.1 since the
> pg_dump_all run OVER 30 hours and for this I need to increase the
> UPS-Backup power for at least 3 days in case of performance problems.
In-place upgrades are not supported at this stage. (This is a
PostgreSQL limitation.) For this reason, we try to combine PostgreSQL
updates with hardware migrations.
Does the 560 GB include indices? 30 hours sounds excessive.
More information about the Pkg-postgresql-public
mailing list