PostgreSQL 9.0: High Performance

Packt Publishing Ltd
2
Free sample

Accelerate your PostgreSQL system. Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database. This book is aimed at intermediate to advanced database administrators using or planning to use PostgreSQL. Portions will also interest systems administrators looking to build or monitor a PostgreSQL installation, as well as developers interested in advanced database internals that impact application design.
Read more
4.5
2 total
Loading...

Additional Information

Publisher
Packt Publishing Ltd
Read more
Published on
Oct 20, 2010
Read more
Pages
442
Read more
ISBN
9781849510318
Read more
Language
English
Read more
Genres
Computers / General
Read more
Content Protection
This content is DRM free.
Read more
Read Aloud
Available on Android devices
Read more

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
Enhance the performance of your PostgreSQL system with this handy guide while avoiding common pitfalls that can slow it down.About This BookLearn the right techniques to obtain optimal PostgreSQL database performance, ranging from initial design to routine maintenanceFine tune the performance of your queries and avoid the common pitfalls that can slow your system downContains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solutionWho This Book Is For

This book is for intermediate to advanced database administrators and developers who use or plan to exploit the features of PostgreSQL in the best possible manner. While administrators can benefit from the topics related to the installation, configuration, and optimization of the server, developers will learn how to write optimal queries and address performance issues in their database design. This book will also benefit the PostgreSQL internal architects in being able to monitor the performance using benchmarking tools.

What You Will LearnLearn the best practices to configure your PostgreSQL 9.6 database for optimal performanceWrite optimal queries and techniques to detect performance issue in queriesFine tune the performance of your queries using benchmarking and indexing techniquesEnsure high performance and a highly available database using the scaling and replication techniquesDiscover how to make informed speed and reliability trade-offsHandle increasing database workloads without any hassleUse monitoring insights to continuously rework the design and configuration for best performanceIn Detail

Database administrators and developers spend years learning techniques to configure their PostgreSQL database servers for optimal performance, mostly when they encounter performance issues. Scalability and high availability of the database solution is equally important these days. This book will show you how to configure new database installations and optimize existing database server installations using PostgreSQL 9.6.

You will start with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. You will not only learn to optimize your database and queries for optimal performance, but also detect the real performance bottlenecks using PostgreSQL tools and some external tools. Next, you will learn how to benchmark your hardware and tune your operating system. Optimize your queries against the database with the help of right indexes, and monitor every layer, ranging from hardware to queries. Moving on, you will see how connection pooling, caching, partitioning, and replication will help you handle increasing database workloads.

Achieving high database performance is not easy, but you can learn it by using the right guide—PostgreSQL 9.6 High Performance.

Style and approach

This book has been organized in such a manner that will help you understand basic PostgreSQL 9.6 performance tuning to advanced-level configuration. There are many real-world problems explained in this book and explained in clear language, because improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples.

Red Tobruk, the war memoir of the Captain of HMS Eridge from late 1940 until August 1942 is a superb account of wartime action at sea. Frank Gregory-Smith_s war started on the destroyer Jaguar and he saw action off Norway and during the Dunkirk evacuation, when she was hit by enemy air attack with 25 men killed. Command of the new escort destroyer HMS Eridge followed (he was to be her only Captain) and they deployed to the Eastern Mediterranean, and so began a gruelling 18 months of convoys to Tobruk and Malta under German controlled skies. ORed Tobruk_ was the name for the enemy aircraft warning that the Tobruk radar station put out which all sailors dreaded as it meant yet another attack was imminent. Eridge survived countless such attacks. She fought in the famous Battle of Sirte when the powerful Italian fleet was seen off. She had to pick up survivors, take stricken ships in tow and once had only blanks to fire at attacking enemy aircraft. Among Eridge_s achievements was the sinking of U-568 in May 1942. The author's luck finally ran out in August 1942 when Eridge was torpedoed by an Italian MTB. Under constant air attack, she was towed to Alexandria but was irreparable. Saddened by the loss of his ship but cheered by the Allies' increasing superiority, Gregory-Smith returned to Britain having been awarded two DSOs and one DSC (a second followed at D-Day). All this and more is told in the most graphic and moving fashion in this exceptional memoir, which will recall to many readers that naval classic The Cruel Sea. The big difference, of course, is that Red Tobruk is a true personal account.
©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.