From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Magnus Hagander <mha@sollentuna.net>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-www@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Steve Wampler <swampler@noao.edu>
Cc: Postgres-performance <pgsql-performance@postgresql.org>
Subject: Re: [PERFORM] Help speeding up delete
Date: Thu, 17 Nov 2005 23:05:10 +0800
Message-ID: <437C9C26.309@familyhealth.com.au> (raw)
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE6C7BF2@algol.sollentuna.se>
References: <6BCB9D8A16AC4241919521715F4D8BCE6C7BF2@algol.sollentuna.se>
>>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.
>
> 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?
Erm. Usually when you install the new package/port for 8.1, you cannot
have both new and old installed at the same time man. Remember they
both store exactly the same binary files in exactly the same place.
>>In my experience not many pgsql admins have test servers or
>>the skills to build up test machines with the latest pg_dump,
>
> I don't, but I still dump with the latest version - works fine both on
> linux and windows for me...
So you're saying you DO have the skills to do it then...
>>etc. (Seriously.) In fact, few realise at all that they
>>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 :-)
It'll make it easy...
Chris
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: chriskl@familyhealth.com.au, mha@sollentuna.net, simon@2ndquadrant.com, tgl@sss.pgh.pa.us, swampler@noao.edu
Subject: Re: [PERFORM] Help speeding up delete
In-Reply-To: <437C9C26.309@familyhealth.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox