Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] reduce page overlap of GiST indexes built using sorted method - Mailing list pgsql-hackers

From sergei sh.
Subject Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
Date
Msg-id 612e90c2-4aac-2919-51e3-f905975656b7@kontur.io
Whole thread Raw
In response to Re: [PATCH] reduce page overlap of GiST indexes built using sorted method  (Aliaksandr Kalenik <akalenik@kontur.io>)
Responses Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
List pgsql-hackers
Tree view 
Hi,

I've addressed Andrey Borodin's concerns about v2 of this patch by 
Aliaksandr
Kalenik in attached version. Change list:
* Number of pages to collect moved to GUC parameter 
"gist_sorted_build_page_buffer_size".
* GistSortedBuildPageState type renamed to GistSortedBuildLevelState.
* Comments added.

Sorted build remaind deterministic as long as picksplit implementation 
for given
opclass is, which seem to be true for builtin types, so setting random 
seed is
not required for testing.

Andrey Borodin's GiST support patch for amcheck was used to verify built 
indexes:
https://commitfest.postgresql.org/25/1800/
PSA modified version working with current Postgres code (btree functions
removed).
Attachment

pgsql-hackers by date:

Previous
From: Juan José Santamaría Flecha
Date:
Subject: Re: [PATCH] allow src/tools/msvc/clean.bat script to be called from the root of the source tree
Next
From: Tom Lane
Date:
Subject: Re: Allow root ownership of client certificate key