NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitbf14575

committed

Fix tuple counting in SP-GiST index build.

Count the number of tuples in the index honestly, instead of assumingthat it's the same as the number of tuples in the heap. (It might bedifferent if the index is partial.)Back-patch to all supported versions.Tomas VondraDiscussion:https://postgr.es/m/3b3d8eac-c709-0d25-088e-b98339a1b28a@2ndquadrant.com

1 parent76e2b5a commitbf14575Copy full SHA for bf14575

File tree

1 file changed

-1

lines changed

src/backend/access/spgist
- spginsert.c

1 file changed

-1

lines changed

`‎src/backend/access/spgist/spginsert.c`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -32,6 +32,7 @@`
`32`	`32`	`typedefstruct`
`33`	`33`	`{`
`34`	`34`	`SpGistStatespgstate;/* SPGiST's working state */`
	`35`	`+int64indtuples;/* total number of tuples indexed */`
`35`	`36`	`MemoryContexttmpCtx;/* per-tuple temporary context */`
`36`	`37`	`}SpGistBuildState;`
`37`	`38`
`@@ -59,6 +60,9 @@ spgistBuildCallback(Relation index, HeapTuple htup, Datum *values,`
`59`	`60`	`MemoryContextReset(buildstate->tmpCtx);`
`60`	`61`	`}`
`61`	`62`
	`63`	`+/* Update total tuple count */`
	`64`	`+buildstate->indtuples+=1;`
	`65`	`+`
`62`	`66`	`MemoryContextSwitchTo(oldCtx);`
`63`	`67`	`MemoryContextReset(buildstate->tmpCtx);`
`64`	`68`	`}`
`@@ -132,6 +136,7 @@ spgbuild(Relation heap, Relation index, IndexInfo *indexInfo)`
`132`	`136`	`*/`
`133`	`137`	`initSpGistState(&buildstate.spgstate,index);`
`134`	`138`	`buildstate.spgstate.isBuild= true;`
	`139`	`+buildstate.indtuples=0;`
`135`	`140`
`136`	`141`	`buildstate.tmpCtx=AllocSetContextCreate(CurrentMemoryContext,`
`137`	`142`	`"SP-GiST build temporary context",`
`@@ -145,7 +150,8 @@ spgbuild(Relation heap, Relation index, IndexInfo *indexInfo)`
`145`	`150`	`SpGistUpdateMetaPage(index);`
`146`	`151`
`147`	`152`	`result= (IndexBuildResult*)palloc0(sizeof(IndexBuildResult));`
`148`		`-result->heap_tuples=result->index_tuples=reltuples;`
	`153`	`+result->heap_tuples=reltuples;`
	`154`	`+result->index_tuples=buildstate.indtuples;`
`149`	`155`
`150`	`156`	`returnresult;`
`151`	`157`	`}`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitbf14575

File tree

1 file changed

1 file changed

`‎src/backend/access/spgist/spginsert.c`

0 commit comments