Re: Use of inefficient index in the presence of dead tuples

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Use of inefficient index in the presence of dead tuples
Дата
Msg-id CAApHDvrrXUZ+u--+hv02XH=L8U=mZLbkk605ueVOohaOYcoFVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Use of inefficient index in the presence of dead tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, 29 May 2024 at 12:53, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> It would be interesting to see a non-artificial example that took
> into account when the last auto-vacuum and auto-analyze really
> happened, so we could see if there's any less-fragile way of
> dealing with this situation.

I think we need to find a way to give some additional preference to
using indexes with more keys matching to quals.

David



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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Long running query causing XID limit breach
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: Memory issues with PostgreSQL 15