Мэдлэгийн сан мэйлийн жагсаалтын архивууд

PostgreSQL tuning

аар
Наранбаяр.М
- 2019.01.02 09:35:57

    shared_buffers --> The PostgreSQL I/O cache
    work_mem --> Parameter to tune sorting, grouping, etc.
    maintenance_work_mem --> Speed up administrative tasks such as VACUUM, etc.
    temp_buffers --> Speed up temporary tables
    effective_cache_size --> Tell PostgreSQL about the amount of memory in your server.
    wal_buffers --> More speed for the transaction log