Re: Massive table (500M rows) update nightmare - Mailing list pgsql-performance

From Craig James
Subject Re: Massive table (500M rows) update nightmare
Date
Msg-id 4B4F8A49.7010906@emolecules.com
Whole thread Raw
In response to Re: Massive table (500M rows) update nightmare  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Responses Re: Massive table (500M rows) update nightmare
List pgsql-performance
Carlo Stonebanks wrote:
> Guys, I want to thank you for all of the advice - my client has just
> made a surprise announcement that he would like to set start from
> scratch with a new server, so I am afraid that all of this great advice
> has to be seen in the context of whatever decision is made on that. I am
> out there, hat-in-hand, looking for advice under the PERFORM post: "New
> server to improve performance on our large and  busy DB - advice?"

You might start this as a new topic with a relevant title, and reiterate your database requirements.  Otherwise it will
getsubmerged as just a footnote to your original question.  It's really nice to be able to quickly find the
new-equipmentdiscussions. 

Craig

pgsql-performance by date:

Previous
From: "Fernando Hevia"
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Next
From: Scott Marlowe
Date:
Subject: Re: New server to improve performance on our large and busy DB - advice?