Re: Massive table (500M rows) update nightmare

From: Craig James <craig_james(at)emolecules(dot)com>
To: Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Massive table (500M rows) update nightmare
Date: 2010-01-14 21:19:05
Message-ID: 4B4F8A49.7010906@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 get submerged as just a footnote to your original question. It's really nice to be able to quickly find the new-equipment discussions.

Craig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-01-14 21:22:09 Re: new server I/O setup
Previous Message Eduardo Piombino 2010-01-14 21:01:33 Re: a heavy duty operation on an "unused" table kills my server