Having massive memory issues due to postgresstore using pg promise under the hood which has its own separate db pool. Even though you guys expose the db instance, it uses pg promise and drizzle doesn't support it. Really desperately need the option of using the neon serverless driver which has compatibility also with planetscale (https://planetscale.com/docs/postgres/connecting/neon-serverless-driver), so that we can do http connections and not just tcp. This makes it feasible to use mastra memory/storage in serverless environments. Otherwise its just too memory intensive and crashes, and becomes very tempting to just get rid of mastra storage/memory instead of having to wrestle with it.
This would require little effort for you guys to implement but be a massive help. Even if you don't support neon-serverless-postgres-driver (https://neon.com/docs/serverless/serverless-driver) , at least supporting postgres-js, or letting us put in our own postgres client.
The Neon serverless driver is a low latency Postgres driver for JavaScript and TypeScript that allows you to query data from serverless and edge environments over HTTP or WebSockets in place of TCP. T...