Re: [EXT] Re: Troubleshooting a long running delete statement

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: [EXT] Re: Troubleshooting a long running delete statement
Дата
Msg-id CADkLM=c8TNqEM4ZATNq5Q-nGV7wrNeSY3s8By+x61HkFT=_r7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [EXT] Re: Troubleshooting a long running delete statement  (Maciek Sakrejda <m.sakrejda@gmail.com>)
Список pgsql-performance
Дерево обсуждения


This won't be immediately useful, but there's been a patch proposed for Postgres 15 to allow logging the plan of a running query [1]. Progress seems to have stalled a bit, but it seems like there was a fair amount of interest, so I wouldn't count it out yet. If you have thoughts on the proposed functionality, I'm sure thoughtful feedback would be appreciated.



Didn't something get into v14 about doing ctd range scans, which would allow you to break up a large update/delete into chunks, so you wouldn't do a full seq scan, but you also would avoid needing an index as a proxy for batching records?

 

В списке pgsql-performance по дате отправления:

Предыдущее
От: Maciek Sakrejda
Дата:
Сообщение: Re: [EXT] Re: Troubleshooting a long running delete statement
Следующее
От: Jeremy Schneider
Дата:
Сообщение: Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle