Документ взят из кэша поисковой машины. Адрес оригинального документа : http://www.sai.msu.su/~megera/postgres/gist/doc/
Дата изменения: Unknown
Дата индексирования: Sat Dec 22 07:15:49 2007
Кодировка:

Поисковые слова: m 17
GLI - GiST layered insertion algorithm

GLI algorithm

GiST home | Introduction | GiST interface (Russian) | Readings
Search PostgreSQL resources | OpenFTS | PostgreSQL site

Under construction !

Case 1: Single split - no space for itup insertion to leaf
Old algorithmGLI algorithm
Step 1: split leaf page and insert itup into leaf1(ex)


Step 2: adjust parent(internal page) for 'leaf'


Step 3: adjust parent(root page) for 'internal'


Step 4: insert link to leaf1 in internal page


Step 5: adjust parent(root page) for 'internal'


Step 1: split leaf page and insert itup into leaf1(ex)


Step 2: delete old link and add two link in internal page to leaf & leaf1


Step 3: adjust parent(root page) for 'internal'


Case 2: Two split - no space on internal page for insertion link to leaf1
Old algorithmGLI algorithm
Step 1: split leaf page and insert itup into leaf1(ex)


Step 2: adjust parent(internal page) for 'leaf'


Step 3: adjust parent(root page) for 'internal'


Step 4: insert link to leaf1 in internal page and split internal page


Step 5: adjust parent(root page) for 'internal'


Step 6: insert link to internal1 to internal page


Step 1: split leaf page and insert itup into leaf1(ex)


Step 2: delete old link and add two link in internal page to leaf & leaf1, then split internal page


Step 3: delete old link and add two link in root page to internal & internal1