I am trying to use pg_vector to build the ivfflat index. I need a maitenance memory between 200MB to 800MB depending on parameters.
The default is 67 MB. Is it possible to change these settings in Neon?
Hi,
You should be able to manually set your session-local maintenance_work_mem to a higher value using SET maintenance_work_mem = <value>.
Please note, however, that instances are operating in environments with limited resources, and this may result in a resource usage that is temporarily larger than was assigned to your instance, which can result in unexpected behaviour.
2 Likes