What tasks have you performed with PostgreSQL?

I performed the following tasks with PostgreSQL:

• Setting up and optimizing database performance (indexes, partitioning, parameter tuning).
• Backing up and restoring data using pg_dump and pg_restore.
• Writing and optimizing complex SQL queries, including the use of window functions and CTEs.
• Automating tasks with scripts and the cron scheduler.
• Monitoring database health and analyzing logs.
• Configuring replication and ensuring high availability.
• Working with PostgreSQL extensions, such as PostGIS for geospatial data.

An example of a simple query using a window function:

SELECT user_id, order_date, SUM(amount) OVER (PARTITION BY user_id ORDER BY order_date) AS running_total
FROM orders;