By sponsoring PGConf NYC 2025, your company can be a part of building the local PostgreSQL community! Check out our sponsorship opportunities today!

https://2025.pgconf.nyc/sponsors/

@PostgreSQL #postgres #conference

With #PostgreSQL 17 came many substantial changes to how #Postgres deployments are handled; notably, logical replication saw many enhancements that help companies achieve true #Postgres high availability & distribution (even relating to system upgrades across major versions). Read about it, and see related blogs for PG17 updates introduced, in this blog from Ahsan Hadi:

https://www.pgedge.com/blog/preserving-replication-slots-across-major-postgres-versions-postgresql-high-availability-for-major-upgrades

#opensource #foss #oss #data #datamanagement #dataanalysis #iot #ai #applicationdeveloper #dev #tech

Как мы внедрили векторный поиск в Postgres Pro

В статье разберемся, что такое векторный поиск, какие проблемы он решает, и как расширение pgpro_vector для Postgres Pro позволяет реализовать эти мощные возможности прямо в реляционной базе данных, без необходимости развертывать отдельные специализированные системы.

https://habr.com/ru/companies/postgrespro/articles/919552/

#векторизация #вектор #векторные_базы_данных #векторный_поиск #postgres #postgres_pro #разработка_баз_данных #администрирование_баз_данных

PgUS is looking for volunteers! We have jobs both large and small so even if you only have a little time to give, we’d love to hear from you!

https://docs.google.com/forms/d/e/1FAIpQLScbgAsSLbvdmx89SsYMDxLM6pkpVNloXmOYWxP9bbdcZBR1vA/viewform

#PostgreSQL #postgres #volunteer

We hope you’ll be joining us on Tuesday, July 8th at Noon PDT for "Compiling Postgres to WASM with PGlite" with Sam Willis!

https://www.meetup.com/postgresql-1/events/308417558/?eventOrigin=group_events_list

@PostgreSQL #PostgreSQL #postgres #meetup

Not only can you join data across databases, but you can join it across clouds! The sky is no longer the limit.

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

#Postgres Parallel Query Troubleshooting | Crunchy Data Blog https://www.crunchydata.com/blog/postgres-parallel-query-troubleshooting

Can't wait to participate in PGConf NYC 2025? Early bird registration is now open! We look forward to seeing you this fall!

https://2025.pgconf.nyc/tickets/

@PostgreSQL #postgres #conference

📍 Space is limited - register now:
👉 https://www.vshn.ch/en/blog/learn-more-about-postgresql-with-core-member-bruce-momjian/

#PostgreSQL #Postgres #BruceMomjian #OpenSource #DatabaseTalk #Zürich #DevOps #VSHN #EDB #CloudNative #VSHNtower #TechEvent #Meetup

One more reason to choose #Postgres over #MySQL

https://tanin.nanakorn.com/one-more-reason-to-use-postgres-vs-mysql/

#transactionalDDL

Why write SQL when Nexus does it for you? It saves time and comes out perfect every time.

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

It’s happening tomorrow! Postgres for All is presenting “10 Costly Database Mistakes (and How to Fix Them)” with Andrew Atkinson! This is an online event; RSVP now!

https://www.meetup.com/postgres-meetup-for-all/events/307033306/?eventOrigin=group_upcoming_events

#PostgreSQL #postgres

Watch how you can diagnose incidents in seconds using #opensource, #eBPF-powered observability. 👇🐧 🐝

Track all communications between cluster components such as #Patroni, #Postgres, #Pgbouncer, and the #Kubernetes API server: https://github.com/coroot/coroot

#Linux #FOSS #observability #postgresql #DevOps #SRE

Happening Wed 18 Jun at 12noon PDT (new time this time) is a LIVE recording of Ep28 of the #TalkingPostgres #podcast with guest Peter Cooper @cooperx86 to talk about "12 years of Postgres Weekly"

Ever wonder how Peter creates such popular (and fun-to-read) newsletters for developers? I'm hoping he will share his secrets for Postgres Weekly!

Join us on Discord to be part of the parallel live text chat https://aka.ms/TalkingPostgres-Ep28-cal

Boosts always appreciated 🚀

#Postgres #PostgreSQL #community #newsletters #PostgresWeekly #OpenSource

Planning on attending PGConf NYC 2025? We have a discounted rate with Club Quarters Hotel, Times Square-Midtown! Check it out and book today:

https://2025.pgconf.nyc/venue/

@PostgreSQL #postgres #conference

Why write SQL when Nexus does it for you? It saves time and comes out perfect every time.

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

Education and advocacy are top priorities for our Diversity Committee. Click the link below to find out more!

https://postgresql.us/diversity/

#PostgreSQL #postgres #diversity #inclusion

PGConf NYC is a non-profit, community run event designed to build and grow the community. As a sponsor, you are doing more than attending the event - you are participating in the community!

https://2025.pgconf.nyc/sponsors/

@PostgreSQL #postgres #conference

Aaand upgrade done, overall took ~30min to migrate my family #Nextcloud from #Sqlite3 to #Postgres

It does feel much snappier now, especially when loading many thumbnails.

Unfortunately the process does take a software engineering degree to finish (--clean-schema does not work due to missing `drop table oc_news_* ... *cascade*`), it's a lot of babysitting and manual corrections.

Early Bird tickets are still available, but don’t wait! Get your ticket to PGConf NYC 2025 today!

https://2025.pgconf.nyc/tickets/

@PostgreSQL #postgres #conference