Fill fields, review the preview, then copy or open elsewhere.
Leave a field empty to keep its placeholder in the preview.
Design a PostgreSQL learning plan.
My SQL background: {{sql_level}}
Why I'm learning Postgres specifically: {{why}}
My role: {{role}}
Daily time: {{daily_time}}
Return:
1. Postgres-specific superpowers: JSONB, arrays, generated columns, full-text search
2. Advanced features: CTEs, window functions, LATERAL joins, materialized views
3. Indexes deeply: B-tree, GIN, GiST, BRIN, partial, expression indexes — when to use each
4. Performance: EXPLAIN ANALYZE, pg_stat_statements, slow query analysis
5. Transactions and isolation levels — what Postgres does differently
6. Replication, partitioning, vacuum — the operational concepts I need
7. PostGIS, pgvector — when to lean on Postgres extensions
8. Connection pooling (PgBouncer) and why it matters
9. Real projects to drill the above
10. The Postgres anti-patterns I should know to avoid