What do you do in Postgres? Do you design schemas?

In Postgres, several key tasks are usually performed:

• Database schema design: creating tables, defining relationships (foreign keys), indexes, and integrity constraints.
• Query optimization: writing efficient SQL queries, using EXPLAIN to analyze performance.
• Working with transactions: ensuring atomicity of operations, managing locks.
• Implementing business logic at the database level: creating functions, triggers, procedures in PL/pgSQL.

Schema design is an important stage that includes normalization of data, planning the structure to support business requirements and scalability. For example, when designing, they consider which data will be frequently queried together to minimize the number of JOINs.