Read Replicas on the Free Plan
You may have seen the announcement earlier this week: Read replicas are now available in the Free Plan.
If you're not familiar Neon Read Replicas, you might be interested to know that we take a fundamentally different approach by leveraging our serverless architecture. In Neon, read replicas are independent compute instances designed to handle read operations on the same data as your primary read-write compute. There's no replication or copying of data involved, allowing you to create a read replica almost instantly with no additional storage cost.
Neon's Read Replicas support a variety of use cases, including:
- Horizontal scaling
- Analytics and ad-hoc queries
- Read-only data access
To learn more about Neon Read Replicas, check out these docs and articles:
- Neon Read Replica documentation
- Blog: The problem with Postgres replicas
- Case Study: Neon Read Replicas in The Wild: How BeatGig Uses Them
Postgres extension updates
We added support for several extensions to Postgres 17, including pgvector 7.4.
Now available on Postgres 17:
Extension | Version |
---|---|
hypopg | 1.4.1 |
pg_hint_plan | 1.7.0 |
pg_ivm | 1.9 |
pg_partman | 5.1.0 |
pg_uuidv7 | 1.6.0 |
pgvector | 7.4 |
pgtap | 1.3.3 |
plv8 | 3.2.3 |
rdkit | 4.6.0 |
timescaledb | 2.17.0 |
wal2json | 2.6 |
In addition, we updated the following extension versions on Postgres 14, 15, and 16:
Extension | Old Version | New Version |
---|---|---|
hypopg | 1.4.0 | 1.4.1 |
pg_ivm | 1.7 | 1.9 |
pg_partman | 5.0.1 | 5.1.0 |
pg_uuidv7 | 1.0.1 | 1.6.0 |
pgvector | 7.2 | 7.4 |
pgtap | 1.2.0 | 1.3.3 |
plpgsql_check | 2.5.3 | 2.7.11 |
wal2json | 2.5 | 2.6 |
For a complete list of Postgres extensions supported by Neon and upgrade instructions, see Postgres extensions.
Neon SQL Editor AI features are now open to everyone
The AI-driven features in the Neon SQL Editor we opened to Early Access users a few weeks ago are now available to everyone. In case you missed that announcement, here's what's new:
- SQL generation: Convert natural language requests to SQL with ease. Press the ✨ button or use Cmd/Ctrl+Shift+M, type your request, and the AI assistant will generate the corresponding SQL. It’s schema-aware, so you can reference table names, functions, and other objects in your schema.
- Fix with AI: When your query returns an error, click Fix with AI next to the error message. The AI assistant will analyze the issue, suggest a fix, and update the SQL Editor so you can run the query again.
- AI-generated query names: Queries in the Neon SQL Editor's History are automatically assigned descriptive names. This feature helps you quickly identify and reuse previous queries.
To learn more, see Neon SQL Editor AI features.
Easier User to Org account conversion
We've introduced a new way to convert personal Neon accounts to organization accounts. Previously, this process required setting up a new organization, transferring projects, and entering billing details again. You can now convert your user account to an organization with a single action. This will instantly transfer all of your projects and billing to the new organization, with no service disruption and no changes to your connections. Your personal account will automatically switch to the Free Plan after conversion.
For more details on how to convert your account, see Convert your personal account.
And don't forget to check out this week's fixes and improvements:
Fixes & improvements
-
Neon Console enhancement
We added a Settings option to the Account navigation sidebar in the Neon Console for easier access to personal and organization account settings.
-
Neon API changes
- Updated the Create Project API to return a 404 error instead of a 500 error when an invalid region is specified.
- Updated the
project_id
field for the Get consumption metrics for each project API. You can now specify project IDs as a comma-separated list in addition to an array of parameter values. This provides more flexibility when filtering responses by project. If omitted, the response will include all projects.- As an array:
project_ids=cold-poetry-09157238&project_ids=quiet-snow-71788278
- As a comma-separated list:
project_ids=cold-poetry-09157238,quiet-snow-71788278
- As an array:
-
Fixes
We fixed an issue with the Neon Vercel Integration where the
PGPASSWORD
variable in Vercel was not defined as expected after enabling branch protection on the main branch. Enabling branch protection resulted in a new password being generated for preview branches, rendering the existingPGPASSWORD
setting invalid. To prevent this issue, aPGPASSWORD
variable is now set for each new preview branch.