#postgres18 — Public Fediverse posts

Huge amount of work for the recent #postgres18 release !

#postgres #fosdem #fosdem26

Huge amount of work for the recent #postgres18 release !

#postgres #fosdem #fosdem26

Huge amount of work for the recent #postgres18 release !

#postgres #fosdem #fosdem26

Huge amount of work for the recent #postgres18 release !

#postgres #fosdem #fosdem26

Huge amount of work for the recent #postgres18 release !

#postgres #fosdem #fosdem26

Postgres 18 cải tiến: Skip Scan - Vượt qua giới hạn chỉ mục bên trái #Postgres18 #SkipScan #CảiTiếnCơSởDữLiệu #DatabaseImprovement #PostgreSQL

https://www.reddit.com/r/programming/comments/1p5ylmq/postgres_18_improvement_highlight_skip_scan/

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/postgres-18-uuid-7.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/postgres-18-uuid-7.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/postgres-18-uuid-7.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/postgres-18-uuid-7.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/postgres-18-uuid-7.html

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18

#HackerNews #Benchmarking #Postgres #Postgres17 #Postgres18 #DatabasePerformance #TechNews

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18

#HackerNews #Benchmarking #Postgres #Postgres17 #Postgres18 #DatabasePerformance #TechNews

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18

#HackerNews #Benchmarking #Postgres #Postgres17 #Postgres18 #DatabasePerformance #TechNews

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18

#HackerNews #Benchmarking #Postgres #Postgres17 #Postgres18 #DatabasePerformance #TechNews

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18

#HackerNews #Benchmarking #Postgres #Postgres17 #Postgres18 #DatabasePerformance #TechNews

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/202510130840.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/202510130840.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/202510130840.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/202510130840.html

Did you know that UUIDv7 is also supported by Python 3.14?

I along with my colleague Alexander Fridriksson are diving into some of the new features in #postgres18. We just released our look at UUIDv7.

UUIDv7 is almost a no brainer for new projects, simplifying indexing strategies and giving you a time-based organizing feature across multiple sources.

Stay tuned as there will be more to explore in PostgreSQL 18 and you can try it all out for free on the Aiven Platform.
https://kjaymiller.com/microblog/202510130840.html

Why the fuck would the official #Postgres17 #Docker #Container store persistent data in its #Volume in /var/lib/postgresql/data but #Postgres18 store persistent data in /var/lib/postgresql?

And why the FUCK would the official #Nginx Docker Container only store persistent data for /etc/nginx and not /etc? Which means you lose all of your #LetsEncrypt #certificates when a new #image is pulled?

Fucking hell.

Why the fuck would the official #Postgres17 #Docker #Container store persistent data in its #Volume in /var/lib/postgresql/data but #Postgres18 store persistent data in /var/lib/postgresql?

And why the FUCK would the official #Nginx Docker Container only store persistent data for /etc/nginx and not /etc? Which means you lose all of your #LetsEncrypt #certificates when a new #image is pulled?

Fucking hell.

Why the fuck would the official #Postgres17 #Docker #Container store persistent data in its #Volume in /var/lib/postgresql/data but #Postgres18 store persistent data in /var/lib/postgresql?

And why the FUCK would the official #Nginx Docker Container only store persistent data for /etc/nginx and not /etc? Which means you lose all of your #LetsEncrypt #certificates when a new #image is pulled?

Fucking hell.

Why the fuck would the official #Postgres17 #Docker #Container store persistent data in its #Volume in /var/lib/postgresql/data but #Postgres18 store persistent data in /var/lib/postgresql?

And why the FUCK would the official #Nginx Docker Container only store persistent data for /etc/nginx and not /etc? Which means you lose all of your #LetsEncrypt #certificates when a new #image is pulled?

Fucking hell.

🤯

https://pganalyze.com/blog/postgres-18-async-io#benchmark-on-aws-doubling-read-performance--even-greater-gains-from-io_uring

#postgresql #postgres18 #postgres #async

🤯

https://pganalyze.com/blog/postgres-18-async-io#benchmark-on-aws-doubling-read-performance--even-greater-gains-from-io_uring

#postgresql #postgres18 #postgres #async

🤯

https://pganalyze.com/blog/postgres-18-async-io#benchmark-on-aws-doubling-read-performance--even-greater-gains-from-io_uring

#postgresql #postgres18 #postgres #async

🤯

https://pganalyze.com/blog/postgres-18-async-io#benchmark-on-aws-doubling-read-performance--even-greater-gains-from-io_uring

#postgresql #postgres18 #postgres #async

🤯

https://pganalyze.com/blog/postgres-18-async-io#benchmark-on-aws-doubling-read-performance--even-greater-gains-from-io_uring

#postgresql #postgres18 #postgres #async

🚀 PostgreSQL 18.0 is out!

Major highlights: asynchronous I/O for faster scans, virtual generated columns (default), OAuth authentication, temporal constraints, uuidv7(), and pg_upgrade with stats preservation.

https://dropletdrift.com/postgresql-18-0-released-with-major-performance-security-and-usability-enhancements/

#PostgreSQL #Postgres18 #Database #OpenSource #SQL #RDBMS #Cloud #Data #AI #BigData #Analytics #DevOps #Security #OAuth #UUID #Performance #Scalability #Engineering #DBA #Tech

🚀 PostgreSQL 18.0 is out!

Major highlights: asynchronous I/O for faster scans, virtual generated columns (default), OAuth authentication, temporal constraints, uuidv7(), and pg_upgrade with stats preservation.

https://dropletdrift.com/postgresql-18-0-released-with-major-performance-security-and-usability-enhancements/

#PostgreSQL #Postgres18 #Database #OpenSource #SQL #RDBMS #Cloud #Data #AI #BigData #Analytics #DevOps #Security #OAuth #UUID #Performance #Scalability #Engineering #DBA #Tech

🚀 PostgreSQL 18.0 is out!

Major highlights: asynchronous I/O for faster scans, virtual generated columns (default), OAuth authentication, temporal constraints, uuidv7(), and pg_upgrade with stats preservation.

https://dropletdrift.com/postgresql-18-0-released-with-major-performance-security-and-usability-enhancements/

#PostgreSQL #Postgres18 #Database #OpenSource #SQL #RDBMS #Cloud #Data #AI #BigData #Analytics #DevOps #Security #OAuth #UUID #Performance #Scalability #Engineering #DBA #Tech

🚀 PostgreSQL 18.0 is out!

Major highlights: asynchronous I/O for faster scans, virtual generated columns (default), OAuth authentication, temporal constraints, uuidv7(), and pg_upgrade with stats preservation.

https://dropletdrift.com/postgresql-18-0-released-with-major-performance-security-and-usability-enhancements/

#PostgreSQL #Postgres18 #Database #OpenSource #SQL #RDBMS #Cloud #Data #AI #BigData #Analytics #DevOps #Security #OAuth #UUID #Performance #Scalability #Engineering #DBA #Tech

🚀 PostgreSQL 18.0 is out!

Major highlights: asynchronous I/O for faster scans, virtual generated columns (default), OAuth authentication, temporal constraints, uuidv7(), and pg_upgrade with stats preservation.

https://dropletdrift.com/postgresql-18-0-released-with-major-performance-security-and-usability-enhancements/

#PostgreSQL #Postgres18 #Database #OpenSource #SQL #RDBMS #Cloud #Data #AI #BigData #Analytics #DevOps #Security #OAuth #UUID #Performance #Scalability #Engineering #DBA #Tech

The latest #Postgres release is just around the corner, and with it comes upgrades for everything from performance, security, developer experience, and beyond. 🚀

Get the full breakdown of what's in the works from a dev's perspective in our latest blog from Ahsan Hadi on "Highlights of #PostgreSQL 18": https://hubs.la/Q03Grvsw0

#tech #data #opensource #oss #foss #sql #database #developer #dba #postgres18

The latest #Postgres release is just around the corner, and with it comes upgrades for everything from performance, security, developer experience, and beyond. 🚀

Get the full breakdown of what's in the works from a dev's perspective in our latest blog from Ahsan Hadi on "Highlights of #PostgreSQL 18": https://hubs.la/Q03Grvsw0

#tech #data #opensource #oss #foss #sql #database #developer #dba #postgres18

The latest #Postgres release is just around the corner, and with it comes upgrades for everything from performance, security, developer experience, and beyond. 🚀

Get the full breakdown of what's in the works from a dev's perspective in our latest blog from Ahsan Hadi on "Highlights of #PostgreSQL 18": https://hubs.la/Q03Grvsw0

#tech #data #opensource #oss #foss #sql #database #developer #dba #postgres18

The latest #Postgres release is just around the corner, and with it comes upgrades for everything from performance, security, developer experience, and beyond. 🚀

Get the full breakdown of what's in the works from a dev's perspective in our latest blog from Ahsan Hadi on "Highlights of #PostgreSQL 18": https://hubs.la/Q03Grvsw0

#tech #data #opensource #oss #foss #sql #database #developer #dba #postgres18

The latest #Postgres release is just around the corner, and with it comes upgrades for everything from performance, security, developer experience, and beyond. 🚀

Get the full breakdown of what's in the works from a dev's perspective in our latest blog from Ahsan Hadi on "Highlights of #PostgreSQL 18": https://hubs.la/Q03Grvsw0

#tech #data #opensource #oss #foss #sql #database #developer #dba #postgres18

According to the 2025 Stack Overflow Developer Survey, Postgres is the #1 database in every major category: most used, most wanted, most loved.

It’s a powerful reflection of how far the Postgres community has come and why the upcoming #Postgres18 release in September will matter even more.

In this post, Tom Kincaid, EDB SVP Database Servers and Tools, walks through eight years of survey data that chart Postgres’s incredible rise. Check it out: https://www.enterprisedb.com/blog/postgresqls-incredible-trip-top-developers-0

According to the 2025 Stack Overflow Developer Survey, Postgres is the #1 database in every major category: most used, most wanted, most loved.

It’s a powerful reflection of how far the Postgres community has come and why the upcoming #Postgres18 release in September will matter even more.

In this post, Tom Kincaid, EDB SVP Database Servers and Tools, walks through eight years of survey data that chart Postgres’s incredible rise. Check it out: https://www.enterprisedb.com/blog/postgresqls-incredible-trip-top-developers-0

According to the 2025 Stack Overflow Developer Survey, Postgres is the #1 database in every major category: most used, most wanted, most loved.

It’s a powerful reflection of how far the Postgres community has come and why the upcoming #Postgres18 release in September will matter even more.

In this post, Tom Kincaid, EDB SVP Database Servers and Tools, walks through eight years of survey data that chart Postgres’s incredible rise. Check it out: https://www.enterprisedb.com/blog/postgresqls-incredible-trip-top-developers-0

🥳🎉 Alert: Postgres 18 is finally making disk reads *not* feel like pulling teeth with new Asynchronous I/O! After years of us pretending to be excited, it's finally here and it's... still under development! 🙄 But hey, at least there's a webinar to "watch" while we wait for the magic to happen. 📈🔄
https://pganalyze.com/blog/postgres-18-async-io #Postgres18 #AsynchronousIO #DatabaseUpdates #TechWebinar #DiskPerformance #HackerNews #ngated

🥳🎉 Alert: Postgres 18 is finally making disk reads *not* feel like pulling teeth with new Asynchronous I/O! After years of us pretending to be excited, it's finally here and it's... still under development! 🙄 But hey, at least there's a webinar to "watch" while we wait for the magic to happen. 📈🔄
https://pganalyze.com/blog/postgres-18-async-io #Postgres18 #AsynchronousIO #DatabaseUpdates #TechWebinar #DiskPerformance #HackerNews #ngated

🥳🎉 Alert: Postgres 18 is finally making disk reads *not* feel like pulling teeth with new Asynchronous I/O! After years of us pretending to be excited, it's finally here and it's... still under development! 🙄 But hey, at least there's a webinar to "watch" while we wait for the magic to happen. 📈🔄
https://pganalyze.com/blog/postgres-18-async-io #Postgres18 #AsynchronousIO #DatabaseUpdates #TechWebinar #DiskPerformance #HackerNews #ngated

🥳🎉 Alert: Postgres 18 is finally making disk reads *not* feel like pulling teeth with new Asynchronous I/O! After years of us pretending to be excited, it's finally here and it's... still under development! 🙄 But hey, at least there's a webinar to "watch" while we wait for the magic to happen. 📈🔄
https://pganalyze.com/blog/postgres-18-async-io #Postgres18 #AsynchronousIO #DatabaseUpdates #TechWebinar #DiskPerformance #HackerNews #ngated

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

https://pganalyze.com/blog/postgres-18-async-io

#HackerNews #Postgres18 #AsynchronousIO #DiskReads #DatabasePerformance

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

https://pganalyze.com/blog/postgres-18-async-io

#HackerNews #Postgres18 #AsynchronousIO #DiskReads #DatabasePerformance

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

https://pganalyze.com/blog/postgres-18-async-io

#HackerNews #Postgres18 #AsynchronousIO #DiskReads #DatabasePerformance

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

https://pganalyze.com/blog/postgres-18-async-io

#HackerNews #Postgres18 #AsynchronousIO #DiskReads #DatabasePerformance