Re: Performance Anomalies in 7.4.5

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance Anomalies in 7.4.5
Дата
Msg-id 2815.1098981088@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance Anomalies in 7.4.5  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Performance Anomalies in 7.4.5
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
>> One drawback to this is that it would require an additional lseek per table
>> while planning, but that doesn't seem like a huge penalty.

> Hmmm ... would the additional lseek take longer for larger tables, or would it
> be a fixed cost?

Should be pretty much a fixed cost: one kernel call per table.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Performance Anomalies in 7.4.5
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: Performance Anomalies in 7.4.5