pull down to refresh

PostgreSQL 17 Released!www.postgresql.org/about/news/postgresql-17-released-2936/
260 sats \ 3 comments \ @Rsync25 26 Sep tech
write
preview
related posts
42 sats \ 0 replies \ @k00b 26 Sep
gainz
  • High concurrency workloads may see up to 2x better write throughput due to improvements with write-ahead log (WAL) processing. Additionally, the new streaming I/O interface speeds up sequential scans (reading all the data from a table) and how quickly ANALYZE can update planner statistics.
  • introduces a new internal memory structure for vacuum that consumes up to 20x less memory
  • improves the performance of queries with IN clauses that use B-tree indexes
  • includes several improvements for query planning, including optimizations for NOT NULL constraints, and improvements in processing common table expressions (WITH queries)
reply
0 sats \ 0 replies \ @eroc1990 26 Sep
Ugh. Not looking forward to the upgrade process, but excited for the performance bumps.
reply
0 sats \ 0 replies \ @monogram 26 Sep freebie
Wow, this is an impressive release!
I'm truly excited for the vacuum improvements and the incremental backups. These are the biggest pain points I have with PostgreSQL at the moment and to stop relying on external programs and scripts to handle them is awesome!