Re: Killing dead index tuples before they get vacuumed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Killing dead index tuples before they get vacuumed
Дата
Msg-id 5191.1022082468@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Killing dead index tuples before they get vacuumed  (Jan Wieck <janwieck@yahoo.com>)
Ответы Re: Killing dead index tuples before they get vacuumed  (Jan Wieck <janwieck@yahoo.com>)
Список pgsql-hackers
Jan Wieck <janwieck@yahoo.com> writes:
>     Also,  in  btree haven't we had some problems with index page
>     splits when using entries large enought so that not at  least
>     3 of them fit on a page?

Right, that's why I said that the limit would only go up to ~10K anyway;
btree won't take keys > 1/3 page.
        regards, tom lane


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Killing dead index tuples before they get vacuumed
Следующее
От: Tom Lane
Дата:
Сообщение: Internal state in sequence.c is a bad idea