Re: FSM search modes
| От | Kevin Grittner |
|---|---|
| Тема | Re: FSM search modes |
| Дата | |
| Msg-id | 4AC49338020000250002B546@gw.wicourts.gov обсуждение исходный текст |
| Ответ на | Re: FSM search modes (Simon Riggs <simon@2ndQuadrant.com>) |
| Ответы |
Re: FSM search modes
Re: FSM search modes |
| Список | pgsql-hackers |
Simon Riggs <simon@2ndQuadrant.com> wrote: > It would be more useful to think of this as "look for huge chunks of > space and fill them" rather than "start at beginning", since space > won't always be right at start. Either I misunderstand you or I disagree. If there's a huge chunk of space near the end, and many many smaller spaces spread throughout, what I'd like is for rows to be placed in those small ones. This would minimize the number of pages to read for queries, and would present some possibility that the rows past the huge chunk might eventually be deleted or non-HOT updated, allowing the bloat to eventually be cleaned up with minimal pain. -Kevin
В списке pgsql-hackers по дате отправления: