Re: Discarding relations from FSM

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Discarding relations from FSM
Дата
Msg-id 25176.1127604079@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Discarding relations from FSM  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: Discarding relations from FSM  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> Rather than keeping track of which relation was last used (presumably
> everytime something hits the FSM), wouldn't it make more sense to just
> drop the relation with the smallest amount of free space in the map?

Why?  That certainly wouldn't be cheaper to track.

> Of course maybe a better question is why we even limit based on the
> number of relations...

Shared memory is fixed-size.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: \x output blowing up
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: \d on database with a lot of tables is slow