Author Topic: Performance Tuning PostgreSQL  (Read 466 times)

0 Members and 1 Guest are viewing this topic.

Offline h2obubbler

  • Full Member
  • *
  • Posts: 228
  • Karma: +0/-0
  • Life is like a box of chocolate.
    • View Profile
Performance Tuning PostgreSQL
« on: October 21, 2008, 05:40:30 PM »
On my research, i found this great article regarding PostgreSQL. i thought sharing with you guys in case you need this in the future.

Many Thanks


=====================================================
Performance Tuning PostgreSQL
by Frank Wiles
Introduction

PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a problem. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can\'t.

The problem is that every database is not only different in its design, but also its requirements. Some systems are used to log mountains of data that is almost never queried. Others have essentially static data that is queried constantly, sometimes feverishly. Most systems however have some, usually unequal, level of reads and writes to the database. Add this little complexity on top of your totally unique table structure, data, and hardware configuration and hopefully you begin to see why tuning can be difficult.

The default configuration PostgreSQL ships with is a very solid configuration aimed at everyone\'s best guess as to how an "average" database on "average" hardware should be setup. This article aims to help PostgreSQL users of all levels better understand PostgreSQL performance tuning.


http://www.revsys.com/writings/postgres ... mance.html

Techronnati | where technology never sleeps

Performance Tuning PostgreSQL
« on: October 21, 2008, 05:40:30 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
435 Views
Last post October 21, 2008, 04:57:28 PM
by h2obubbler
0 Replies
432 Views
Last post October 21, 2008, 05:10:29 PM
by h2obubbler
1 Replies
736 Views
Last post September 09, 2014, 03:00:28 AM
by JusticeLeague

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.