Lightlines
By manutej

postgresql-database-engineering

manutej1.8k installs

Build faster, more reliable PostgreSQL databases.

What it does

Guides the design, optimization, and maintenance of PostgreSQL databases for better performance and reliability.

When to use it

Use when optimizing slow queries, configuring replication, or implementing backup and recovery.

How to use it

It changes how the agent designs, optimizes, and maintains PostgreSQL databases, supplying SQL examples and operational guidance.

What you provide

  • An existing project

Uses

Good to know

  • cannot be undone: /var/lib/postgresql/14/main; PostgreSQL; /archive/wal/

Latest review

What you need · 0

No setup requirements listed.


Access · 3

This skill

/var/lib/postgresql/14/main

Write

Deletes the standby data directory (irreversible)

PostgreSQL

Execute

Restarts the standby database service

Write

Drops old database partitions (irreversible)

/archive/wal/

Write

Copies database transaction archives (irreversible)