search

pramsey / pgsql-postal

PostgreSQL binding for libpostal
MIT License
138 stars 20 forks source link

Is it possible to keep libpostal loaded beyond connections? #17

Closed stiivo closed 2 years ago

stiivo commented 2 years ago

Hi, at first, thanks for that great extension.

Because I am not yet so familiar with postgres, I asked myself whether it is possible that the extension is loaded at the start of the postgres daemon and is available for all connections instead of reloading the extension for each connection and thus repeatedly occupying several gb of memory as long as the connection exists.

i hope i have been able to explain my concern in a halfway decent way.

thanks a lot

pramsey commented 2 years ago

Each backend (connection) get its own copy.