Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: [PERFORM] Help speeding up delete
Date: Thu, 17 Nov 2005 16:39:06 +0100
Message-ID: <6BCB9D8A16AC4241919521715F4D8BCE6C7C03@algol.sollentuna.se>
Thread-Topic: [pgsql-www] [PERFORM] Help speeding up delete
thread-index: AcXriFF+MaR09uvOR3ivzN3N2SRPNQABHMjA
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Simon Riggs" <simon@2ndquadrant.com>,
	<pgsql-www@postgresql.org>, "Tom Lane" <tgl@sss.pgh.pa.us>,
	"Steve Wampler" <swampler@noao.edu>,
	"Postgres-performance" <pgsql-performance@postgresql.org>

> >>That way if someone wanted to upgrade from 7.2 to 8.1, they=20
> can just=20
> >>grab the latest dumper from the website, dump their old=20
> database, then=20
> >>upgrade easily.
> >=20
> > But if they're upgrading to 8.1, don't they already have the new=20
> > pg_dump? How else are they going to dump their *new* database?
>=20
> Erm.  Usually when you install the new package/port for 8.1,=20
> you cannot have both new and old installed at the same time=20
> man.  Remember they both store exactly the same binary files=20
> in exactly the same place.

Urrk. Didn't think of that. I always install from source on Unix, which
doesn't have the problem. And the Windows port doesn't have this problem
- it will put the binaries in a version dependant directory.

One could claim the packages are broken ;-), but that's not gonig to
help here, I know...

(I always install in pgsql-<version>, and then symlink pgsql there..)


> >>etc.  (Seriously.) In fact, few realise at all that they should use=20
> >>the 8.1 dumper.
> >=20
> > That most people don't know they should use the new one I=20
> understand=20
> > though. But I don't see how this will help against that :-)
>=20
> It'll make it easy...

You assume they know enough to download it. If they don't know to look
for it, they still won't find it.

But the bottom line: I can see how it would be helpful if you're on a
distro which packages postgresql in a way that prevents you from
installing more than one version at the same time.

//Magnus