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 10:19:28 +0100
Message-ID: <6BCB9D8A16AC4241919521715F4D8BCE6C7BF2@algol.sollentuna.se>
Thread-Topic: [pgsql-www] [PERFORM] Help speeding up delete
thread-index: AcXrU4k7PjwS8+z1TDi66qZLjnVilgABDMAQ
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>,
	"Simon Riggs" <simon@2ndquadrant.com>
Cc: <pgsql-www@postgresql.org>, "Tom Lane" <tgl@sss.pgh.pa.us>,
	"Steve Wampler" <swampler@noao.edu>,
	"Postgres-performance" <pgsql-performance@postgresql.org>

> > Perhaps we should put a link on the home page underneath LATEST=20
> > RELEASEs saying
> > 	7.2: de-supported
> >=20
> > with a link to a scary note along the lines of the above.
> >=20
> > ISTM that there are still too many people on older releases.
> >=20
> > We probably need an explanation of why we support so many=20
> releases (in=20
> > comparison to licenced software) and a note that this does=20
> not imply=20
> > the latest releases are not yet production (in comparison=20
> to MySQL or=20
> > Sybase who have been in beta for a very long time).
>=20
> By the way, is anyone interested in creating some sort of=20
> online repository on pgsql.org or pgfoundry where we can keep=20
> statically compiled pg_dump/all for several platforms for 8.1?
>=20
> That way if someone wanted to upgrade from 7.2 to 8.1, they=20
> can just grab the latest dumper from the website, dump their=20
> old database, then upgrade easily.

But if they're upgrading to 8.1, don't they already have the new
pg_dump? How else are they going to dump their *new* database?

> In my experience not many pgsql admins have test servers or=20
> the skills to build up test machines with the latest pg_dump,=20

I don't, but I still dump with the latest version - works fine both on
linux and windows for me...=20

> etc.  (Seriously.) In fact, few realise at all that they=20
> should use the 8.1 dumper.

That most people don't know they should use the new one I understand
though. But I don't see how this will help against that :-)

//Magnus