Re: [PERFORM] Help speeding up delete

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-www(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Steve Wampler <swampler(at)noao(dot)edu>, Postgres-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] Help speeding up delete
Date: 2005-11-17 15:05:10
Message-ID: 437C9C26.309@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-www

>>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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-11-17 15:07:42 Re: Help speeding up delete
Previous Message Vivek Khera 2005-11-17 14:34:52 Re: Hardware/OS recommendations for large databases (5TB)

Browse pgsql-www by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-11-17 15:07:42 Re: Help speeding up delete
Previous Message Steinar H. Gunderson 2005-11-17 11:19:27 Re: Help speeding up delete