--- title: "Tips, tips, and more PG tips" publication: "Postgres Weekly" issue: 516 published_at: "2023-07-26" canonical_url: "https://postgresweekly.com/issues/516" --- Plus a big update for the Postgres C++ client, DigitalOcean adds pgvector, and the PGConf NYC 2023 schedule is up. | #​516 — July 26, 2023 [Web Version](https://postgresweekly.com/issues/516) Together with [![Crunchydata\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_430,h_100/e_make_transparent/co_white,e_outline:7/xyflkz7n00elwtgja9ne.png)](https://www.crunchydata.com/products/crunchy-bridge?utm_source=cppg-prim-0721) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/v7rbnepgzc8ey5fs1uke.jpg)](https://postgres.ai/blog/20230722-10-postgres-tips-for-beginners) [10 Postgres Tips for Beginners](https://postgres.ai/blog/20230722-10-postgres-tips-for-beginners) — The author is one of the co-hosts of the [🎤 Postgres.fm podcast](https://postgres.fm/) and he and his co-host have come up with some thoroughly explained, thoughtful tips. They're admittedly at the more entry level end, but worth a skim nonetheless. Nikolay Samokhvalov (Postgres․ai) 💡 We do love a good set of tips, so if you want more, [this collection of 152 `psql` tips](https://psql-tips.org/psql_tips_all.html) is handy whatever your skill level. 🕒 [The Intricacies of Time and Timestamp Data Types](https://www.cockroachlabs.com/blog/time-data-types-postgresql/) — A thorough look at the practicalities of using types like `TIMESTAMP` and `TIMESTAMPTZ`, their related functions and operators, and how to work with timezones in queries. Oliver Tan (Cockroach Labs) [![\](https://copm.s3.amazonaws.com/39e99d1f.png)](https://www.crunchydata.com/products/crunchy-bridge?utm_source=cppg-prim-0721) [We’re All About Great Postgres Support](https://www.crunchydata.com/products/crunchy-bridge?utm_source=cppg-prim-0721) — "What a different support experience Crunchy is. Not only is it timely, it's informed, it's on topic. We’re encouraged to ask questions. We’re able to do so much more working with a partner who cares as much about data as we do." Rob Sullivan, CareRev. Crunchydata sponsor [The Basics of Using JSON(B) in Postgres](https://www.crunchydata.com/developers/playground/basics-of-jsonb) — This is a pretty neat, interactive way to learn about the power of Postgres’s JSON features including manipulating, querying, saving, and optimizing a simple object structure all within a [browser-based Postgres environment.](https://www.crunchydata.com/blog/crazy-idea-to-postgres-in-the-web-browser) Crunchy Data **IN BRIEF:** - DigitalOcean's managed Postgres service [now supports the pgvector extension.](https://docs.digitalocean.com/products/databases/postgresql/#17-july-2023) - 📅 PGConf NYC 2023 is taking place in New York City this October and [has just released the full schedule,](https://postgresql.us/events/pgconfnyc2023/schedule/) including a keynote from Andy Pavlo, talks from folks like Claire Giordano, Bruce Momjian, Ryan Booz, and more. - Not content with pushing the envelope with time series data indexing and querying, Timescale is now [turning its hand to vectors and AI](https://www.timescale.com/ai/) and you can register an initial interest in a service currently being called _Timescale Vector._ - [Postgres 15 is now generally available](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/postgresql-v15-is-now-generally-available-in-flexible-server/ba-p/3878447) on _Azure Database for PostgreSQL Flexible Server._ - We recently shared an update from the _PostgreSQL Community Association_ (which manages the 'PostgreSQL' trademark) on [actions it's taking to defend the trademark](https://www.postgresql.org/about/news/update-on-continued-trademark-actions-against-the-postgresql-community-2673/) against alleged infringement by a Spanish Postgres advocacy group. Álvaro Hernández of _Fundación PostgreSQL_ has fired back with ["The Postgres Core Team tries to Shut Down a Postgres Community Conference"](https://postgresql.fund/blog/the-postgres-core-team-tries-to-shut-down-a-postgres-community-conference/) – it seems this one will rumble on for a while yet. [Hurting Performance with Partitioning?](https://www.cybertec-postgresql.com/en/killing-performance-with-postgresql-partitioning/) — _“… using too many partitions will significantly increase the time the planner needs to do its job. Having hundreds of partitions can easily lead to a real disaster.”_ Hans-Jürgen Schönig ▶[Postgres Can Do What Now?](https://www.youtube.com/watch?v=cy-QL6a_J4M) — A 37-minute talk touching on a variety of topics like pivot tables, window functions, and row level security. Vagmi Mudumbai [How to Measure the Network's Impact on Postgres Performance](https://www.percona.com/blog/how-to-measure-the-network-impact-on-postgresql-performance/) — In most cases, Postgres isn’t running on the same server as the apps using it, so the network can have an impact on performance. Despite this, it’s not particularly easy to measure _what_ that impact is from the database side, but the ‘wait events’ info from `pg_stat_activity` can provide some clues. Jobin Augustine [How PostgresML Generates JS and Python SDKs from a Canonical Rust SDK](https://postgresml.org/blog/how-we-generate-javascript-and-python-sdks-from-our-canonical-rust-sdk) — [PostgresML](https://postgresml.org/) is an extension that adds machine learning functions into Postgres. Its team loves and prefers Rust but most of its users are using JavaScript or Python. What to do? Simultaneously write multi-language libraries using Rust.. Silas Marvin (PostgresML) ▶[How to Enable Change Data Capture on Amazon RDS Postgres](https://www.youtube.com/watch?v=0NTsUMb_diQ) Gunnar Morling Code and Tools [PgCat 1.1: A Modern Postgres Pooler and Proxy](https://github.com/postgresml/pgcat) — Built in Rust, PgCat offers support for sharding (including, experimentally, based upon SQL syntax), load balancing and failover support. [v1.1](https://github.com/postgresml/pgcat/releases/tag/v1.1.0) adds support for prepared statements and server TLS connections. PostgresML [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/qiaelobszxsekguxdthj.jpg)](https://pganalyze.com/blog/introducing-vacuum-advisor-postgres?utm_source=PostgresWeeklySecondary07262023) [Introducing the New pganalyze VACUUM Advisor for Postgres](https://pganalyze.com/blog/introducing-vacuum-advisor-postgres?utm_source=PostgresWeeklySecondary07262023) pganalyze sponsor [libpqxx 7.8: The Official C++ Client API for Postgres](https://github.com/jtv/libpqxx/releases/tag/7.8.0) — _Lots of goodies_, they say. C++17 users get a new array class for working wtih SQL arrays, faster large data set streaming, lots of bug fixes, improved exceptions, and more. [Main repo.](https://github.com/jtv/libpqxx) Jeroen Vermeulen [Aquameta 0.4: A Web Stack Built Atop Postgres](https://github.com/aquametalabs/aquameta) — An “all database” web development stack organized around several Postgres extensions. Aquameta [PgBouncer 1.20.0: The Lightweight Connection Pooler](https://www.pgbouncer.org/2023/07/pgbouncer-1-20-0) — Introduces better support for tracking PG settings using a new `track_extra_parameters` setting, which can be used to track `search_path` in combination with Citus 12+. It also now connects using TLS by default and a variety of bugs have been squashed. PgBouncer Team [An Oracle to Postgres Migration: 7 Tools That Make It Possible](https://www.eversql.com/my-oracle-to-postgresql-migration-the-7-tools-that-made-it-possible/) Oded Valin (EverSQL) **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|*).