Postgres Pro
Downloads
Home   >   mailing lists

Re: GSoC 2011: Fast GiST index build - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: GSoC 2011: Fast GiST index build
Date
Msg-id 4DC39D7E.4040501@sigaev.ru
Whole thread Raw
In response to Re: GSoC 2011: Fast GiST index build  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: GSoC 2011: Fast GiST index build  (Alexander Korotkov <aekorotkov@gmail.com>)
List pgsql-hackers
Tree view 
> As I understood it's because we can't move root to another page.

Actually not. Path to node could change completely, For example, for page on 
second level path is 0-234 (where 0 is a root page, 234 is a page on second 
level). After root split path will be 0-new_page-234.

If algorithm could be able to change root then new path could be looked as 
new_root-new_page-234 because old root could be splitted to old_root_page and 
new_page.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: clog_redo causing very long recovery time
Next
From: Josh Berkus
Date:
Subject: Why not install pgstattuple by default?