Tuning_for_High_Write_Workload.md

Tuning PostgreSQL for High Write workload

1. Use WAL Compression

2. Increase max_wal_size

3. Hot Update

4. Remove Randomness

   Example: UUID is randomness reduces the write performance in B-Tree

   What to do if PRIMARY KEY is UUID?

    Prefix UUID with date. YYYYMMDDHH24
   

5. Vacuuming