Neon Branching capabilities are not publicly available yet. If you would like to try out this feature, reach out to firstname.lastname@example.org describing your use case and request to enable branching capabilities for your account.
A branch is a copy of the project data created from the current state or any past state that is still available (see PITR). A branch can be independently modified from its originating project data.
You can use a branch to:
- Run potentially destructive queries without impacting your main branch
- Run time travel queries against historical state
- Run a set of queries with separate resources to avoid impacting your application
- Tag and name the current moment, for PITR convenience or ML model training repeatability
- Run your tests against a branch from production data
Note: The branch creation process does not increase load on the originating project. You can create a branch at any time without worrying about downtime or performance degradation.
A Neon user is identified by their email address.
A user registers and authenticates in Neon Web UI with their GitHub or Google account. More authentication methods are coming soon.
- WAL: PostgreSQL uses a Write Ahead Log (WAL) for durability and replication. In Neon, we additionally rely on this WAL to separate storage from compute.
- LSN: Log Sequence Number, a byte offset into a location inside the entire WAL stream.
- Page: An 8KB chunk of data, which is the smallest unit of storage that PostgreSQL uses for storing relations and indexes on disk. In Neon, a page is also the smallest unit of data the Pageserver can be queried for. See PostgreSQL Database Page Layout.
PostgreSQL users are created as a part of your Neon Project and can be managed via the Neon web UI. A system user
web-access is used for the SQL Editor in Neon UI and for link authentication for psql. This user cannot be removed or used for authenticating in other scenarios.
The second user is created for client access. The credentials for that user can be managed, this user's credentials can be used for password-based psql authentication too.
More PostgreSQL users can be created in Neon UI.
When a Project is created, a default database for storing data is created along with it, the name of the database is "main". A Neon user can create more databases inside a Project in the Neon UI. Neon users cannot manipulate system databases, such as
A Project is a collection of PostgreSQL databases, PostgreSQL users and other settings on Neon cloud service.
A Project contains a virtual instance with a PostgreSQL server, also called Compute, as well as the storage used to store the Project data. The amount of virtual resources available for the Project is subject to limits defined by the Technical Preview Free Tier.
Compute is stateless and can be automatically activated and suspended due to user activity.