TimescaleDB Memory Tuning: shared_buffers, work_mem, and Chunk Sizing


PostgreSQL memory tuning advice is everywhere: set shared_buffers to 25% of RAM, bump work_mem, set effective_cache_size to 75%. That advice is fine for vanilla PostgreSQL. For TimescaleDB, it is incomplete. The chunk-based architecture introduces a constraint that generic...