Configuration

Autovacuum is disabled globally, which will cause table bloat, stale statistics, and eventual XID wraparound database shutdown.

Debug-level logging is enabled, creating massive log volumes and significant performance overhead.

Every SQL statement is being logged, creating massive log files and significant I/O overhead.

Very few connections are reserved for superusers, which may prevent administrators from connecting during a connection exhaustion crisis.

The autovacuum_freeze_max_age is set higher than recommended, delaying XID freezing and increasing wraparound risk.

Index scans are disabled, forcing all queries to use sequential scans regardless of available indexes.

Index-only scans are disabled, preventing PostgreSQL from using its most efficient scan method for covered queries.

Every query's duration is being logged (log_min_duration_statement = 0), creating excessive log output.

The checkpoint_completion_target is low, causing I/O spikes during checkpoints instead of smooth background writes.

No idle_in_transaction_session_timeout is set, meaning idle transactions can block vacuum and hold locks indefinitely.

No lock_timeout is configured, meaning queries can wait indefinitely for locks instead of failing fast.

No statement_timeout is configured, meaning queries can run indefinitely without being automatically terminated.

Statistics tracking (track_counts) is disabled, which breaks autovacuum and prevents collecting table and index statistics.

Synchronous commit is disabled, meaning committed transactions may be lost in a crash window of up to 600ms.

WAL level is set to minimal, which disables replication and prevents point-in-time recovery.

The database is using MD5 for password hashing, which is cryptographically broken and vulnerable to attacks.

The fsync setting is disabled, meaning PostgreSQL does not ensure data is written to disk. A crash will likely cause unrecoverable data corruption.

The full_page_writes setting is disabled, risking torn page corruption after a crash that cannot be detected or repaired.