Bring Your Own Extensions to Serverless PostgreSQL
Blog post from Neon
Neon has introduced Dynamic Extension Loading for serverless PostgreSQL, allowing for private and custom extensions to be added without restarting compute instances, which run as ephemeral Kubernetes pods or VMs. This approach addresses challenges such as performance issues, security risks, and maintenance overhead in serverless environments by building extensions separately, storing them in an S3 bucket, and enabling on-demand loading. This new mechanism enhances customization by configuring extensions per user and reduces the compute image size, resulting in faster start times. Currently in beta, this feature marks a significant advancement for PostgreSQL's adaptability in serverless contexts, with plans for broader availability in the future.