| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Converting 7.x to 8.x |
| Date: | 2007-01-29 22:04:30 |
| Message-ID: | 45BE6F6E.3080703@cox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 01/29/07 13:20, Vivek Khera wrote:
>
> On Jan 27, 2007, at 10:45 AM, Ron Johnson wrote:
>
>> Using slony or "piped pg_dump" requires that you have *double* the
>> amount of disk space. Having a *very large* database and double
>> capacity of SCSI disks (including storage controllers, shelves, etc,
>> etc) is expensive, and might not be available.
>
> Then one must decide which costs more: 20+ hours of downtime
More like 50 hours:
- - 20 to pg_dump
- - 30 to restore the data and rebuild the indexes.
> or some
> disks and a computer...
Yeah, that would fly like a lead balloon where I work...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFvm9uS9HxQb37XmcRAqa3AJ9HW8aDaddXJeQKHIIjD/C3DmCKwQCglkqR
qkhNxa38GjMLdBeFKpatXck=
=DpX+
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tom | 2007-01-29 22:05:58 | Re: PostgreSQL 9.0 |
| Previous Message | Pierre Thibaudeau | 2007-01-29 21:49:45 | Re: "simple" dict with stop words in tsearch2 |