We just ran into a limit on indexing due to the 'index size cannot be more than 1/3 of page size (2712)' error.
This indicates the buffer page size is 8192 (8k). This seems awfully small during the terabyte era.
This does not seem to be a parameter we can reset in a config file. I can download, build, and install it if needed.
What are the performance considerations? I would think we might benefit substantially on performance with a larger buffer page size. Can someone experienced with PostgreSQL database tuning offer an opinion?