@michristofides speqking about #Postgres buffers and #performance at PGDay UK
#PGDayUK #postgresql

LAST CALL!!!

If you haven’t already made your reservation at Club Quarters Grand Central, do it now! The hotel block closes tonight at midnight EDT! Don’t miss out!

https://buff.ly/41u6Qkv

@PostgreSQL
#PostgreSQL #postgres #conference #pgconfnyc

The hotel block closes on Monday, September 11th! That’s tomorrow! Book your room now at the lovely (and conveniently located) Club Quarters Grand Central!

https://buff.ly/41u6Qkv

@PostgreSQL
#PostgreSQL #postgres #conference #pgconfnyc

From SF PUG:

Our October Meetup is open for RSVP's! Join us on Wednesday, October 11th at 12pm PDT for "Getting Started With Postgres Performance" with Elizabeth Christensen! We hope to see you there!

@sqlliz #PostgreSQL #postgres #meetup

https://buff.ly/3PasZ2E

Welcome HAVELSAN (@HAVELSANResmi) as a Partner sponsor of PGDay UK 2023 in London! https://2023.pgday.uk/sponsors/ #postgres #pgdayuk #london #opensource #database

#Postgres FM | Anniversary mailbag https://share.transistor.fm/s/22ae451a #podcast

First #curl now #postgres? CVE-2020-21469 claims that postgres is vulnerable to a denial of service by sending SIGHUP signals to the process. Users can't send SIGHUP signals to the postgres process though... 😕

This is _not_ a vulnerablity. Vulnerabilities are a mess.

#opensource #Vulnerability #cybersecurity #infosec

Welcome Quest as a Partner sponsor of PGDay UK 2023 in London! https://2023.pgday.uk/sponsors/ #postgres #pgdayuk #london #opensource #database

Based on the latest comments received, I have committed a patch that simplifies even more the format of wait_event_names.txt in the #postgres tree. Let me know if you have more comments about it, but C enum definitions can be git-grepped. https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=59cbf60c0f2b5723ce4a939077c99bf4e4c433d3

If #PostGIS &/or #PostgreSQL is your jam 👋 join us for the live recording of the Path To Citus #podcast on Wed Sep 6th @ 10am PDT

There is a live text chat that happens in parallel to the live podcast recording

Guests @pwramsey & Regina Obe are renowned in the geospatial field

Topic = Why people care about PostGIS & #Postgres

This cal invite has instructions on how to join.

(you can listen to podcast after it is published, but participating live is fun)

Pls boost

https://aka.ms/PathToCitusCon-Ep07-cal

Time flies. One year at AWS as of today, doing #Postgres stuff:
$ git shortlog -s -n --since=2022-09-04 --author=Paquier
330 Michael Paquier

Fix handling of shared statistics with dropped databases, causing autovacuum scheduler to get stuck in #postgres 15~, patch by @AndresFreundTec: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=2b8e5273e949003f299ddcae5f8c4b44c6eb9edc

Optimizing Postgres's autovacuum for high-churn tables

Link: https://tembo.io/blog/optimizing-postgres-auto-vacuum/
Discussion: https://news.ycombinator.com/item?id=37352955

#postgres

Explaining the Postgres iceberg

Link: https://avestura.dev/blog/explaining-the-postgres-meme
Discussion: https://news.ycombinator.com/item?id=37356925

#postgres

START

Me: you should index this 300GB EMR dataset in #Postgres before FA in #Rstats
Analyst: this is going to take for ever. Let's raw dog this.

(7 days later)
Analyst: Should have put the indices in, #SQL queries take forever.
Me: No, let's raw dog this.

(5 months later)
GOTO START

Sharing this overview of the #PostgreSQL work done at Microsoft over the last 12 months. I'm in awe of my teammates, & the many other ppl in PG world we collaborate with 🙌

The workstreams:
- Postgres open source
- Citus database extension
- PG ecosystem e.g. Patroni, PgBouncer, pgcopydb, pg_cron...
- PG community work
- #AzureDBPostgres
- #AzureCosmosDB for PostgreSQL

+1 to the many ppl who reviewed this post & helped bring it to life #OpenSource #Postgres #Citus
https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-new-with-postgres-at-microsoft-august-2023/ba-p/3914506

When should you use the IN instead of the OR operator in Postgres?

Link: https://ottertune.com/blog/query-best-practices-when-should-you-use-the-in-instead-of-the-or-operator
Discussion: https://news.ycombinator.com/item?id=37324518

#postgres

#Postgres Debian/Ubuntu Packaging(Part 2) | This and That https://aklaver.org/wordpress/2023/07/01/postgres-debian-ubuntu-packagingpart-2/

CVE-2020-21469 is not a security vulnerability , #postgres https://www.postgresql.org/about/news/cve-2020-21469-is-not-a-security-vulnerability-2701/

Lesser Known Postgres Features (2021)

Link: https://hakibenita.com/postgresql-unknown-features
Discussion: https://news.ycombinator.com/item?id=37309309

#postgres