PostgreSQL GiST index - how to decide whether to use buffering or not?

One of the PostgreSQL GiST options is to use build buffering . However, I don't feel that the documentation is helpful enough for me to decide whether to use it or not. I also found this presentation https://wiki.postgresql.org/images/0/07/Fast_GiST_index_build.pdf explaining buffering in detail, but I can't figure it out.

To complicate matters, I created GiST indexes with the default setting (buffering = auto), so I don't know if it is being used or not. I have a 15MB dataset which is a map (this is not that much, I understand the effects are minimal, but still I am interested in its effects), so I guess it is static data that can be loaded in bulk. - but is it buffering build bulk loading? If I'm not mistaken, one of the problems with GiST is bulk uploading?

+3
indexing postgresql spatial-index spatial


source to share


No one has answered this question yet

Check out similar questions:

2302
How does database indexing work?
1719
How to exit PostgreSQL command line utility: psql
922
How to run PostgreSQL server on Mac OS X?
850
How to change PostgreSQL user password?
534
How to import CSV files into PostgreSQL table?
442
How can I delete a PostgreSQL database if there are active connections to it?
399
How do I map to an index in Ruby?
392
How do I update + join PostgreSQL?
192
List of columns with indexes in PostgreSQL
34
PostgreSQL: GIN or GiST indexes?



All Articles
Loading...
X
Show
Funny
Dev
Pics