article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

It enables businesses and organizations to meet uptime and service level objectives, protect business-critical data, and maintain performant databases. Backup and continuous archiving: PostgreSQL asynchronous replication relies on the write-ahead log (WAL) stream, and it’s vital to have centralized storage that all nodes can access.

article thumbnail

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. Rich became co-author of the second edition of the Sun Performance Tuning book, to describe how it worked.

Tuning 52
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Is It a Read Intensive or a Write Intensive Workload?

Percona

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. While our white paper Performance at Scale could provide useful insight if you are at the planning or review stage.

article thumbnail

Total Cost of Ownership and the Return on Agility - All Things.

All Things Distributed

An apples to apples comparison of the costs associated with running various usage patterns on-premises and with AWS requires more than a simple comparison of hardware expense versus always-on utility pricing for compute and storage.

AWS 118
article thumbnail

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Percona

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. For bare metals, any algorithm among deadline or noop (the performance difference between them is imperceptible) will be better than CFQ.

article thumbnail

Tuning Autovacuum in PostgreSQL and Autovacuum Internals

Percona

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a high performance PostgreSQL database needed by demanding applications. You May Also Like.

Tuning 44
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

This White Paper is for informational purposes only. ​​ This is similar to the ​​ suspend and resume ​​ operations performed by ​​ the operating system. ​​ MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.

Servers 40