Re: Why could different data in a table be processed with different performance?

Поиск
Список
Период
Сортировка
От Vladimir Ryabtsev
Тема Re: Why could different data in a table be processed with different performance?
Дата
Msg-id CAMqTPqks=FTmxVCoQQfPa=7DxTe1V3eLnJZrXq0B+AgdrPzYWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why could different data in a table be processed with differentperformance?  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
Дерево обсуждения
> If it does an index scan, I think that will badly fail to keep the same order of heap TIDs - it'll be inserting rows in ID order rather than in (I guess) reverse ID order.
According to the plan, it's gonna be seq. scan with filter.

Vlad

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Why could different data in a table be processed with differentperformance?
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Why could different data in a table be processed with differentperformance?