Overview of data access use case
Better performance for analytics
- Run heavy analytical SQL, perform data export without affecting the production servers
- Bring E and T to a replica: a Database Lab Engine can be considered as a specialized replica, where data modifications are allowed on a temporary clones – this approach can simplify ETL processes
- Analysts work with thin clones, which are fully independent
- When a long-lasting query needs to be executed, an analyst can work independently, not interfering with production workload or a colleague's work
- Production servers are not in danger: autovacuum activity is not affected, long-running queries are not causing bloat
This page is unfinished. Reach out to the Postgres.ai team to learn more.