Thoughts on how to avoid a massive integer update.

2020-05-04 Thread Fehrle, Brian
Hi all, This is a shot in the dark in hopes to find a magic bullet to fix an issue I have, I can’t personally think of any solution myself. I have a database with hundreds of terabytes of data, where every table has an integer column referencing a small table. For reasons out of my control and

Re: Thoughts on how to avoid a massive integer update.

2020-05-08 Thread Fehrle, Brian
On 5/4/20, 3:56 PM, "Adrian Klaver" wrote: [External Email] On 5/4/20 2:32 PM, Fehrle, Brian wrote: > Hi all, > > This is a shot in the dark in hopes to find a magic bullet to fix an > issue I have, I can’t personally think

Re: Thoughts on how to avoid a massive integer update.

2020-05-08 Thread Fehrle, Brian
From: "David G. Johnston" Date: Friday, May 8, 2020 at 11:48 AM To: "Fehrle, Brian" Cc: "pgsql-gene...@postgresql.org" Subject: Re: Thoughts on how to avoid a massive integer update. [External Email] On Mon, May 4, 2020 at 2:33 PM Fehrle, Brian mailto:bfeh..

Re: Thoughts on how to avoid a massive integer update.

2020-05-08 Thread Fehrle, Brian
From: Rob Sargent Date: Friday, May 8, 2020 at 11:05 AM To: "Fehrle, Brian" Cc: Adrian Klaver , "pgsql-gene...@postgresql.org" Subject: Re: Thoughts on how to avoid a massive integer update. [External Email] Could you show an example table relationship? It’s

Re: Thoughts on how to avoid a massive integer update.

2020-05-08 Thread Fehrle, Brian
up that way from the beginning (over a decade ago), this is what I’m stuck with. Blah. From: Rob Sargent Date: Friday, May 8, 2020 at 3:05 PM To: "David G. Johnston" Cc: "Fehrle, Brian" , "pgsql-gene...@postgresql.org" Subject: Re: Thoughts on how to