# Base memory settings
shared_buffers = '8GB'               # More RAM for dedicated analytics instance
work_mem = '1GB'                     # Larger for complex sorts/joins
maintenance_work_mem = '2GB'         # Helps with vacuum on large tables
effective_cache_size = '24GB'        # ~75% of RAM for big queries

# Temporary file settings
temp_buffers = '512MB'              # More temp memory for large sorts
temp_file_limit = '5GB'             # Limit disk usage for temp files

# Setting this too high can cause out-of-memory errors!
max_stack_depth = '6MB'             # For deep recursive queries