# PostgreSQL configuration for SurfSense
# This file is mounted into the PostgreSQL container

listen_addresses = '*'
max_connections = 200
shared_buffers = 256MB

# Enable logical replication (required for Zero-cache real-time sync)
wal_level = logical
max_replication_slots = 10
max_wal_senders = 10

# Performance settings
checkpoint_timeout = 10min
max_wal_size = 1GB
min_wal_size = 80MB

# Logging (optional, for debugging)
# log_statement = 'all'
# log_replication_commands = on