--- title: "Amazon RDS adds pgvector support" publication: "Postgres Weekly" issue: 506 published_at: "2023-05-17" canonical_url: "https://postgresweekly.com/issues/506" --- Plus PostgresML raises money, MariaDB looks at Postgres, and how to manage default privileges better. | #​506 — May 17, 2023 [Web Version](https://postgresweekly.com/issues/506) Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklyPrimary05172023) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/fuwivabujfqozqhvidzj.jpg)](https://www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/) [Postgres 15.3, 14.8, 13.11, 12.15, and 11.20 Released](https://www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/) — Two security vulnerabilities and ‘over 80 bugs’ have been resolved in these minor updates to all maintained release lines. Both vulnerabilities are ‘quite old’ ones. The first allowed an attacker with database-level `CREATE` privileges to execute arbitrary code. The second was a more complex one involving row security policies. PostgreSQL Global Development Group [PostgresML Raises $4.7M for Serverless AI Databases](https://postgresml.org/blog/postgresml-raises-4.7M-to-launch-serverless-ai-application-databases-based-on-postgres) — [PostgresML](https://postgresml.org/) is an open-source Postgres-based platform that enables performing modern machine learning related tasks (training models, working with vectors, performing inference) using SQL. Montana Low (PostgresML) In mildly related news, [Amazon RDS now supports pgvector](https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-rds-postgresql-pgvector-ml-model-integration/) for storing embeddings from ML models and performing similarity searches upon them. [![\](https://copm.s3.amazonaws.com/3f517bcb.png)](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklyPrimary05172023) [Best Practices for Optimizing Postgres Query Performance (eBook)](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklyPrimary05172023) — Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk. We share our learnings from helping companies like Atlassian, CounterPath, and others speed up their queries. pganalyze sponsor [Understanding `ALTER DEFAULT PRIVILEGES` Better](https://www.cybertec-postgresql.com/en/postgresql-alter-default-privileges-permissions-explained/) — [Privileges](https://www.postgresql.org/docs/current/ddl-priv.html) provide a way to grant different types of access to different types of objects to different users. `ALTER DEFAULT PRIVILEGES` provides a way to change _default_ privileges for objects created in the future. Laurenz Albe **IN BRIEF:** - Curiously, MariaDB is [working on a Postgres-compatible front-end](https://www.theregister.com/2023/05/10/mariadb_xpand_postgresql/) for its SkySQL DBaaS. - Yet again, the folks at Hacker News tackle the question of [choosing between Postgres and MySQL](https://news.ycombinator.com/item?id=35906604) in depth. Postgres has the edge in the ensuing discussion but some interesting arguments are made for MySQL (and SQLite). - _Cloudflare Workers_ is an edge/serverless functions platform that, due to its use of V8 isolates, hasn't supported direct socket connections, limiting its use with TCP-accessible systems like Postgres. [Till now.](https://blog.cloudflare.com/workers-tcp-socket-api-connect-databases/) - AWS Aurora has added [support for Graviton3-based R7g instances.](https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-aurora-mysql-postgresql-graviton3-based-r7g-instance-family/) The benefits of [R7g instances](https://aws.amazon.com/ec2/instance-types/r7g/) are higher performance, faster memory, and access to larger memory sizes (up to 512GB). - [Ryan Booz](https://postgresql.life/post/ryan_booz/) is this week's _PostgreSQL Person of the Week_ interviewee. As well as creating [PGSQL Phriday](https://www.pgsqlphriday.com/), he lives on a 33 acre farm! [Working with Time in Postgres](https://www.crunchydata.com/blog/working-with-time-in-postgres) — A primer on the basics quickly covering data types, intervals, overlaps, range types, indexing, and roll ups in one place. Elizabeth Christensen [Migration Steps from Redshift to Columnar Postgres (Docs)](https://docs.hydra.so/guides/migrate-from-redshift) Hydra sponsor [The Subtle Art of Code Conversion in Oracle to Postgres Migrations](https://databaserookies.wordpress.com/2023/05/13/subtle-art-of-code-conversion-in-oracle-to-postgresql-migration/) — Despite a plethora of tools available to help, converting code between two such different database systems still requires a huge amount of specialized knowledge. _(Though we await the results of someone trying to get ChatGPT to do it.. 😆)_ Deepak Mahto Though if we remember what Christophe Pettus said last week.. [don't use ChatGPT to solve Postgres problems!](https://thebuild.com/blog/2023/05/09/dont-use-chatgpt-to-solve-problems/) (Yet..) [Evolving django-multitenant to Build Scalable SaaS Apps on Postgres with Citus](https://www.citusdata.com/blog/2023/05/09/evolving-django-multitenant-to-build-scalable-saas-apps-on-postgres-and-citus/) Gürkan İndibay (Citus Data) [Tenant Monitoring in Citus and Postgres with `citus_stat_tenants`](https://www.citusdata.com/blog/2023/05/12/tenant-monitoring-in-citus-and-postgres-with-citus-stat-tenants/) Halil Ozan Akgul (Citus Data) Code and Tools [Bytebase 2.0: Collaborative Database DevOps System](https://www.bytebase.com/blog/bytebase-2-0/) — Describing itself as a ‘GitLab’ for database devops, Bytebase lets you collaborate within a team on things like schema changes, querying, roles and access, etc. It’s open source with a 'pro' paid offering and [v2.0](https://github.com/bytebase/bytebase/releases/tag/2.0.0) includes an all new AI-based index optimization advisor for slow queries. Bytebase - [credcheck 1.2](https://www.postgresql.org/about/news/credcheck-v120-released-2639/) ↳ Username/password checking extension. - [dblab 0.20](https://github.com/danvergara/dblab) ↳ TUI-style database client. - [Dbmate 2.3](https://github.com/amacneil/dbmate) ↳ Agnostic database migration tool. - [pg-online-schema-change / pg-osc 0.8.1](https://github.com/shayonj/pg-osc) ↳ Perform schema changes with minimal locking. - [pg_track_settings 4.1.2](https://www.postgresql.org/about/news/pg_track_settings-412-is-out-2638/) ↳ Keep track of PG settings modifications. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)