Re: Degraded performance during table rewrite

Поиск
Список
Период
Сортировка
От Mohamed Wael Khobalatte
Тема Re: Degraded performance during table rewrite
Дата
Msg-id CABZeWdxCE9ye7jUmRd5UX9CHBnvaDQ1D_Yfxvjgf0+W7hEjfVA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Degraded performance during table rewrite  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Degraded performance during table rewrite
Следующее
От: Zahir Lalani
Дата:
Сообщение: Application Level Encryption