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  ("Oren Mazor" <oren.mazor@gmail.com>)
Re: understanding the interaction with delete/select/vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Oren Mazor"
Дата:
Сообщение: array vs flat tables performance
Следующее
От: "Oren Mazor"
Дата:
Сообщение: Re: understanding the interaction with delete/select/vacuum