Re: FSM search modes
От | Simon Riggs |
---|---|
Тема | Re: FSM search modes |
Дата | |
Msg-id | 1254415503.17864.262.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Re: FSM search modes ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
Ответы |
Re: FSM search modes
|
Список | pgsql-hackers |
On Thu, 2009-10-01 at 11:32 -0500, Kevin Grittner wrote: > 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. Yes, as Tom points out, this must be done with bias away from the very end of the table. I meant that we should start from the beginning of large spaces and that we shouldn't assume that all space worth filling is at start of relation. -- Simon Riggs www.2ndQuadrant.com
В списке pgsql-hackers по дате отправления: