Re: Degraded performance during table rewrite

2020-07-04 Thread Mohamed Wael Khobalatte
On Fri, Jul 3, 2020 at 11:30 PM Mohamed Wael Khobalatte < mkhobala...@grubhub.com> wrote: > Another idea that might conceivably be useful to you on 9.6 is to > > reorganize the bulk deletions so that most of them aren't at the endpoint >> of the live id range. If you made it so that the extremal

Re: Degraded performance during table rewrite

2020-07-04 Thread Tom Lane
Mohamed Wael Khobalatte writes: > Tom, I think I understood what you meant after getting some sleep. What I > do now is: > - Initially load a lot of ids, say a million. > - Then I slice that array by my preferred batch, say a 1. > - Loop through these slices and run an improved query, which

Re: Degraded performance during table rewrite

2020-07-04 Thread Mohamed Wael Khobalatte
> > Right, the problem occurs when you're deleting stuff that's at the end > of the id range, and have already deleted stuff that was previously the > end of the range. If you start somewhere in the middle and work towards > the end, you dodge that problem, even for the very last delete that > *is

Application Level Encryption

2020-07-04 Thread Zahir Lalani
Hello Does anyone have any serious experience of implementing app level encryption with strong key management? If so would like to arrange an offline chat please Z