pgsql_tuneup_guide
Differences
This shows you the differences between two versions of the page.
|
pgsql_tuneup_guide [2012/04/05 19:04] k2patel |
pgsql_tuneup_guide [2020/08/10 02:35] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Tunning PgSQL ====== | ||
| - | This is not so hard because there is tool available to do so thnx to "Greg Smith".\\ | ||
| - | Name of tool is "**pgtune**"\\ | ||
| - | Since Diff. machine has Diff. H.W. Profile you need to have Diff. configuration for diff. machine.\\ | ||
| - | Which make available most H.W. Resources during run time.\\ | ||
| - | |||
| - | I usually tune up using following map. | ||
| - | * Run pgtune and create base of postgres configuration. | ||
| - | * Enable Query Monitoring on System. | ||
| - | * Use PQA / pgfouine / EPQA / Pgsi to analys log. | ||
| - | * Also look in to the checkpoint | ||
| - | |||
| - | |||
| - | ==== Links From Outside ==== | ||
| - | [[http://oss.linbit.com/hugetlb/ | hugetlb]] | ||
pgsql_tuneup_guide.txt ยท Last modified: 2020/08/10 02:35 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
