understanding the interaction with delete/select/vacuum
| От | Alan Stange |
|---|---|
| Тема | understanding the interaction with delete/select/vacuum |
| Дата | |
| Msg-id | 43135DD2.6090004@rentec.com обсуждение исходный текст |
| Ответы |
Re: understanding the interaction with delete/select/vacuum
Re: understanding the interaction with delete/select/vacuum |
| Список | pgsql-novice |
Hello all, say for example I have a larger table T with 26 millions rows, one million associated with each letter of the alphabet. I have a long running process which does a 'SELECT ID FROM T'. The results are being streamed to the client using a fetch size limit. This process with take 26 hours to run. It turns out that all the "C" and "P" are going to be deleted when the SELECT gets to them. Several hours into this process, after the "C" rows have been deleted in a separate transaction but we haven't yet gotten to the "P" rows, a vacuum is begun on table T. What happens? Will the 1 million "C" rows be freed and made available for reuse or will their visibility with the initial SELECT statement cause the vacuum to skip over them? Thanks! -- Alan
В списке pgsql-novice по дате отправления: