What tasks do you perform with Postgres/Oracle in terms of volume and type?

Working with Postgres and Oracle tasks may include:

• Administration: Setting up users, access rights, backup and recovery.
• Query Optimization: Analyzing execution plans, creating indexes, optimizing complex SQL queries.
• Development: Writing and debugging stored procedures, functions, triggers.
• Monitoring: Tracking performance, identifying bottlenecks.
• Data Migrations: Transferring data between environments, updating database schema.

The scope of tasks can vary from supporting small databases to working with large volumes of data (terabytes), requiring scaling and clustering.

Example task: optimizing a slow query by adding an index and rewriting the query to reduce the number of table joins.