Re: Better tracking of free space during SP-GiST index build
От | Robert Haas |
---|---|
Тема | Re: Better tracking of free space during SP-GiST index build |
Дата | |
Msg-id | CA+TgmoYyhhqwh_hSsjr-mkdCEW259h2F9XYB6npj_X+GB9fYpg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Better tracking of free space during SP-GiST index build (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Wed, Sep 28, 2016 at 2:11 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Robert Haas <robertmhaas@gmail.com> writes: >> On Thu, Sep 22, 2016 at 1:37 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >>> OK, I'll think about how to do that more efficiently. The smaller >>> incremental improvement isn't surprising, because in this example the >>> index would still be 90-something MB if it had no free space at all, >>> so there's going to be decreasing returns from any additional work >>> to avoid wasted free space. But if we can do it cheaply, this does >>> suggest that using pages in order by free space is of value. > >> Tom, are you planning to do something about this patch yet this >> CommitFest, or leave it until later? > > I doubt I will get to it this week, so let's mark it RWF for this fest. OK, done. Thanks for the reply. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: