The latest product updates from Neon
bloompgrowlocksintaggpgstattupleearthdistanceaddress_standardizeraddress_standardizer_data_uspg8000 Python PostgreSQL driver, version 1.29.3 and higher, now supports connecting to Neon.EXPLAIN that show prefetch hits and misses for sequential scans.branch_logical_size_limit attribute to the Neon API Project response body, which shows the logical data size limit for project branches. This attribute replaces the logical_size_limit attribute, which was shown in the Branch response body. The Neon Free Tier limits the logical data size of a branch to 3072MB (3GB).project_id in the hostname, are no longer valid. Instead of the project_id, an endpoint_id must be specified in the hostname. For information about constructing a valid connection string, see Connect from any application. An email with migration instructions was sent to affected users.branch or endpoints attributes was required. Without a request body, the default behavior is to create a branch from the project's root branch (main) without an endpoint, and the branch name is auto-generated..env file with the password are provided in a pop-up dialog after creating a project.pg_prewarm PostgreSQL extension, which utilizes the above-mentioned sequential scan prefetch feature. The pg_prewarm extension provides a convenient way to load data into the PostgreSQL buffer cache after a cold start. For information about PostgreSQL extensions supported by Neon, see PostgreSQL extensions.storage_sync operation to make it more robust and reliable while syncing files between Pageservers and S3.logical_size_limit attribute to the branch schema, which shows the data size limit for a branch.max_project_size attribute in Neon API v1 specification to branch_logical_size_limit.max_project_size attribute from Neon v2 API schema.parent_id and name attributes optional when creating a branch.allow_connections flag for endpoints to permit disabling connections to the endpoint.endpoints attribute is not specified. Creating a branch without an endpoint supports backup uses cases and useful in scenarios where the number of branches exceeds the number of available endpoints due to endpoint limits.region_id parameter as region.id. The attribute was previously treated as region.handle. Code that uses these endpoints may need to be updated.main to neondb.TIME and LSN fields to the branch details page for child branches. The TIME field shows the time value selected when creating a branch with data up to a specified point in time. The LSN field shows a Log Sequence Number (LSN), indicating that the branch was created with data up to that LSN.ApiKey tag to API Key."Content-Type" header with an "application/json" value to Neon API v2 error responses.postgres repository to the neon repository and created a separate wal_redo binary in order to reduce the amount of change in the postgres repository codebase.--daemonize option from the CLI process that starts the Pageserver and Safekeeper storage components. The required library is no longer being maintained and the option was only used in our test environment.UI: Added support for the US East (Ohio), Europe (Frankfurt), and Asia Pacific (Singapore) regions, allowing you to create Neon projects closer to your application servers. For more information about Neon's region support, see Regions.
UI: Updated Neon's branching capabilities. The following enhancements were introduced:
main.main) or from another branch in the project.For more information about Neon's branching capabilities, see Branching, and Get started with branching.
Neon Branching capabilities are not yet publicly available. If you would like to try this feature, contact us at iwantbranching@neon.tech, describing your use case and requesting that Neon enable branching for your account.
UI: With the addition of support for new regions and updates to Neon's branching capabilities, changes were made to the hostname in Neon connection strings. Previously, a hostname had this format: <project_id>.cloud.neon.tech. With the introduction of new regions, a <region_slug> and <platform> value were added to the hostname for projects created in newly supported regions. With the update to branching capabilities, <project_id> was replaced by <endpoint_id>. As a result of these changes:
<endpoint_id>.cloud.neon.tech.<endpoint_id>.<region_slug>.<platform>.neon.tech.The old hostname format continues to be supported for projects created before these changes were introduced.
UI: Added highlighting support for PostgreSQL 15 SQL Keywords to Neon's SQL Editor. Keywords are highlighted when entered in the SQL Editor.
UI: Added the ability to display the navigation bar at the top of the Neon Console as a side drawer menu on small screens.
.pgpass configuration instructions provided after creating a project or resetting a password. The instructions did not include the required PostgreSQL port number.410 Gone error when resubmitting an OAuth consent challenge.wal_log_hints parameter, which is the default PostgreSQL setting. The Pageserver-related issue that required enabling wal_log_hints has been addressed, and enabling wal_log_hints is no longer necessary.state field to the TimelineInfo struct that is returned by the timelines internal management API endpoint. Timeline state information improves observability and communication between Pageserver modules.INSERT ... ON CONFLICT handling issue for speculative Write-Ahead Log (WAL) record inserts. Under certain load conditions, records added with INSERT ... ON CONFLICT could be replayed incorrectly.compaction_period setting to 20 seconds to reduce the frequency of polling that is performed to determine if compaction is required. The frequency of polling with the previous setting of 1 could result in excessive CPU consumption when there are numerous tenants and projects.h3_pg and plv8 PostgreSQL extensions. For information about PostgreSQL extensions supported by Neon, see Available PostgreSQL extensions.backpressure_throttling_time function that returns the total time spent throttling since the system was started.read, update, delete project access scopes for OAuth applications.protected: boolean flag to the roles public API response.zenith_ctl binary.Failed to connect to the compute node error.PostGIS extension, version 3.3.0. For information about PostgreSQL extensions supported by Neon, see Available PostgreSQL extensions.options, application_name, and replication connection parameters to compute nodes..pgpass password file instructions that are presented when resetting a password #1825.In progress to Scheduling.max_replication_write_lag to 15 MB to tune the backpressure mechanism and improve PostgresSQL responsiveness under load.uuid-ossp extension binaries, which provide functions for generating universally unique identifiers (UUIDs). CREATE EXTENSION "uuid-ossp" is now supported. For information about extensions supported by Neon, see Available PostgreSQL extensions.423 Locked is now reported instead of 409 Conflict.zenith.page_server_connstring to neon.pageserver_connstringzenith.zenith_tenant to neon.tenant_idzenith.zenith_timeline to neon.timeline_idzenith.max_cluster_size to neon.max_cluster_sizewal_acceptors to safekeeperszenith_admin role to cloud_admin.fullbackup endpoint that works like basebackup but also sends relational files.psql copy.DROP DATABASE is executed.CREATE EXTENSION statement for users that are not database owners.max_lsn_wal_lag default setting to avoid constant reconnections during normal work.wal_connection_attempts maintenance, preventing busy reconnection loops.pooler_enabled property to the project update API call to indicate whether or not connection pooling is enabled.user_id type from int64 to uuid.{ "message": "error text" }.platform, region, and instance_type ids optional during new project creation.web_access system role to be modified or deleted, which could affect the functioning of the Neon SQL Editor.