[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間:2025-08-05 (世界標準時間)。"],[[["This document outlines performance tuning parameters specifically for AlloyDB Omni on a VM, based on various workload tests."],["The suggested parameter changes focus on improving performance for most applications on modern hardware, while keeping most default PostgreSQL parameter values unchanged."],["Key parameters to adjust include `random_page_cost`, `temp_buffers`, `max_wal_size`, `min_wal_size`, `default_toast_compression`, and several memory-related settings like `maintenance_work_mem` and `work_mem`."],["The tuning parameters for `max_worker_processes`, `max_parallel_workers`, and `max_parallel_workers_per_gather` should be adjusted based on the number of vCPUs."],["The `effective_cache_size` parameter is recommended to be set to 80% of DRAM, and `work_mem` should be adjusted from 128 to 512 MB depending on workload and memory availability."]]],[]]