X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F02C8D967F; Thu, 17 Nov 2005 11:56:31 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55332-03; Thu, 17 Nov 2005 15:56:35 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 0E06AD78B6; Thu, 17 Nov 2005 11:56:28 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 17 Nov 2005 09:56:32 -0600 Subject: Re: [PERFORM] Help speeding up delete From: Scott Marlowe To: Christopher Kings-Lynne Cc: Simon Riggs , pgsql-www@postgresql.org, Tom Lane , Steve Wampler , Postgres-performance In-Reply-To: <437BDF9A.4060700@familyhealth.com.au> References: <43790A99.9050603@noao.edu> <4162.1132011763@sss.pgh.pa.us> <1132171206.4959.60.camel@localhost.localdomain> <437BDF9A.4060700@familyhealth.com.au> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1132242992.3582.98.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 17 Nov 2005 09:56:32 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/116 X-Sequence-Number: 8831 On Wed, 2005-11-16 at 19:40, Christopher Kings-Lynne wrote: > > Perhaps we should put a link on the home page underneath LATEST RELEASEs > > saying > > 7.2: de-supported > > > > with a link to a scary note along the lines of the above. > > > > ISTM that there are still too many people on older releases. > > > > We probably need an explanation of why we support so many releases (in > > comparison to licenced software) and a note that this does not imply the > > latest releases are not yet production (in comparison to MySQL or Sybase > > who have been in beta for a very long time). > > By the way, is anyone interested in creating some sort of online > repository on pgsql.org or pgfoundry where we can keep statically > compiled pg_dump/all for several platforms for 8.1? > > That way if someone wanted to upgrade from 7.2 to 8.1, they can just > grab the latest dumper from the website, dump their old database, then > upgrade easily. > > In my experience not many pgsql admins have test servers or the skills > to build up test machines with the latest pg_dump, etc. (Seriously.) > In fact, few realise at all that they should use the 8.1 dumper. I would especially like such a thing available as an RPM. A pgsql-8.1-clienttools.rpm or something like that, with psql, pg_dump, pg_restore, and what other command line tools you can think of that would help.