Skip site navigation (1) Skip section navigation (2)

Re: Massive table (500M rows) update nightmare

From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Massive table (500M rows) update nightmare
Date: 2010-01-14 22:05:48
Message-ID: hio4eh$lig$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
My bad - I thought I had, so it has been re-posted with a (v2) disclaimer in 
the title... like THAT will stop the flaming! <g>

Thanks for your patience!

"Craig James" <craig_james(at)emolecules(dot)com> wrote in message 
news:4B4F8A49(dot)7010906(at)emolecules(dot)com(dot)(dot)(dot)
> 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
>
> -- 
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
> 


In response to

pgsql-performance by date

Next:From: Dave CrookeDate: 2010-01-14 22:35:53
Subject: Re: New server to improve performance on our large and busy DB - advice? (v2)
Previous:From: Scott MarloweDate: 2010-01-14 21:43:29
Subject: Re: New server to improve performance on our large and busy DB - advice?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group