Databases
Create and manage PostgreSQL databases with automatic backups and connection pooling.
SMLL provides fully managed PostgreSQL databases powered by CloudNativePG. Each database runs in your VPC with automatic backups, connection pooling, and optional read replicas.
Creating a database
From your VPC dashboard, click Create Database and configure:
| Field | Description | Default |
|---|---|---|
| Name | Alphanumeric and hyphens only | Required |
| PostgreSQL version | 15, 16, or 17 | 16 |
| Instance size | Compute plan | smll.nano |
| Storage | Disk size in GB (1–100) | Required |
| Replicas | 1–3 instances | 1 |
| Connection pooling | Enable PgBouncer | Enabled |
Instance sizes
| Plan | CPU | Memory | Max connections |
|---|---|---|---|
smll.nano | 0.25 cores | 512 MiB | 50 |
smll.small | 0.5 cores | 1 GiB | 100 |
smll.medium | 1 core | 2 GiB | 200 |
smll.large | 2 cores | 4 GiB | 300 |
smll.xlarge | 4 cores | 8 GiB | 400 |
Connection pooling
Connection pooling is enabled by default via PgBouncer in transaction mode:
- Default pool size: 20
- Max client connections: 200
PgBouncer sits between your application and PostgreSQL, reducing the overhead of opening and closing connections. This is especially useful for serverless workloads or applications with many short-lived connections.
Database status
Your database transitions through these states:
- Creating — provisioning in progress
- Running — healthy and accepting connections
- Stopped — manually stopped or scaled down
- Error — something went wrong; check logs