Re: Degraded performance during table rewrite - Mailing list pgsql-general

From Mohamed Wael Khobalatte
Subject Re: Degraded performance during table rewrite
Date
Msg-id CABZeWdxCE9ye7jUmRd5UX9CHBnvaDQ1D_Yfxvjgf0+W7hEjfVA@mail.gmail.com
Whole thread Raw
In response to Re: Degraded performance during table rewrite  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

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* handling the endmost ids.

                        regards, tom lane

Amazing, thank you very much for your help.  

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Degraded performance during table rewrite
Next
From: Zahir Lalani
Date:
Subject: Application Level Encryption