# Top 3 features in Postgres 17

DevFeed: [Top 3 features in Postgres 17](<https://devfeed.tech/articles/top-3-features-in-postgres-17-5834.md>)

Original publisher: [Read original article](<https://neon.com/blog/top-3-features-in-postgres-17>)

Author: Anastasia Lubennikova

Published: 2024-08-30T16:11:21Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [JSON](<https://devfeed.tech/topics/json.md>), [Developer experience](<https://devfeed.tech/topics/developer-experience.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [developer-experience](<https://devfeed.tech/tags/developer-experience.md>), [json](<https://devfeed.tech/tags/json.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [release](<https://devfeed.tech/tags/release.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

The article highlights three Postgres 17 improvements: MERGE with RETURNING support for handling conditional data changes in one step, expanded JSON functions for querying and transforming semi-structured data, and performance and operational improvements involving parallel queries, vacuum, and B-tree indexes.

## Source excerpt

One more year, Postgres is the most loved and trusted database in the world--and it's about to get better with Postgres 17. This upcoming release comes with improvements both in developer experience and performance. Top 3 features in Postgres 17 MERGE command with RETURNING suppor...