[Pkg-postgresql-public] Re: Default PostgreSQL in Etch

[Michelle Konzack]

Hello Florian,

Am 2007-02-09 18:17:58, schrieb Florian Weimer:
> * 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.

How stable is 8.2 running?  --  As I have tested 8.1 for around
8 month it was the hell.  Nothing was realy working right.

> 
> > 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.

I have upgraded the Hardware for arround 8 month and I have only
performance problems while doing a pg_dump but not in real use
where I have a speed like Google (using tsearch2).

> 
> Does the 560 GB include indices?  30 hours sounds excessive.

No, only the Database itselfm where the maintable is around
400GByte in size.  Using tsearch2 will create indices bigger then
the real database so I exclude them from the pg_dump and rebuild
it after  restoring.

Thanks, Greetings and nice Day
    Michelle Konzack


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20070213/51fbbe90/attachment.pgp