Re: Why Postgres doesn't use TID scan?

Поиск
Список
Период
Сортировка
От Vladimir Ryabtsev
Тема Re: Why Postgres doesn't use TID scan?
Дата
Msg-id CAMqTPq=Ezo21P5ToyfA9Nu0N7LiTm2GzTRJPt5CU3CCp1n4-_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why Postgres doesn't use TID scan?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
OK, good to know.
I saw some timeout errors in the code writing to the log table during my DELETE and decided they are relevant. Probably they had nothing to do with my actions, need to investigate.
Thanks anyway.

Best regards,
Vlad

пн, 17 дек. 2018 г. в 18:32, Tom Lane <tgl@sss.pgh.pa.us>:

DELETE doesn't lock the whole table.  What problem are you actually
facing?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why Postgres doesn't use TID scan?
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: pgbench results arent accurate