Re: Practical limit on number of tables ina single database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Practical limit on number of tables ina single database
Дата
Msg-id 12780.1143244579@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Practical limit on number of tables ina single database  ("Just Someone" <just.some@gmail.com>)
Ответы Re: Practical limit on number of tables ina single database  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
"Just Someone" <just.some@gmail.com> writes:
> Actually, most table are VERY small. On each schema I would expect 4 -
> 5 tables to go over 1000 records. The rest will be much smaller, with
> most at under 100. And aside from 2-3 tables, the activity will be
> pretty low (few records a day at the most extreme).

> Can I use this to optimize the fsm part in a different way?

Seems like a one-page table hardly needs an FSM entry at all: there's
only one place to look for free space anyway.  Maybe we should have a
threshold for the minimum size a table must be before it gets an FSM
entry.

            regards, tom lane

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

Предыдущее
От: "Just Someone"
Дата:
Сообщение: Re: Practical limit on number of tables ina single database
Следующее
От: "Dann Corbit"
Дата:
Сообщение: Re: Between !