Performance Optimization

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(General Setup and Optimization: Fixing link to PostgreSQL Hardware Performance by Bruce Momjian)
(This article is obsolete; talks about Postgres 8.2 and manual VACUUMing. Most other articles cover shared_buffers and effective_cache_size anyway)
 
Line 4: Line 4:
 
* [http://www.pgcon.org/2008/schedule/events/104.en.html GUCs: A Three Hour Tour] by Josh Berkus.  Also useful here is his [http://pgfoundry.org/docman/view.php/1000106/84/calcfactors.sxc tuning OpenOffice spreadsheet], which suggests tuning values for 5 different types of workloads.  
 
* [http://www.pgcon.org/2008/schedule/events/104.en.html GUCs: A Three Hour Tour] by Josh Berkus.  Also useful here is his [http://pgfoundry.org/docman/view.php/1000106/84/calcfactors.sxc tuning OpenOffice spreadsheet], which suggests tuning values for 5 different types of workloads.  
 
* [http://linuxfinances.info/info/quickstart.html QuickStart Guide to Tuning  PostgreSQL] by Christopher Browne
 
* [http://linuxfinances.info/info/quickstart.html QuickStart Guide to Tuning  PostgreSQL] by Christopher Browne
* [http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm 5-Minute Introduction to PostgreSQL Performance] by Greg Smith
 
 
* [http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html Annotated postgresql.conf] by Josh Berkus and Shridhar Daithankar (older V7.4 targeted version of material covered in the GUC tour referenced above)
 
* [http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html Annotated postgresql.conf] by Josh Berkus and Shridhar Daithankar (older V7.4 targeted version of material covered in the GUC tour referenced above)
 
* [http://www.varlena.com/GeneralBits/Tidbits/perf.html Performance Tuning] by Josh Berkus and Shridhar Daithankar
 
* [http://www.varlena.com/GeneralBits/Tidbits/perf.html Performance Tuning] by Josh Berkus and Shridhar Daithankar

Latest revision as of 10:15, 12 February 2014

Contents

[edit] General Setup and Optimization

Performance courses are available from a number of companies. Check events and trainings for further details.

[edit] Critical maintenance for performance

[edit] Database architecture

[edit] Database Hardware Selection and Setup

[edit] Benchmark Workloads

Personal tools