Remove c
article thumbnail

Missing Library: A pg_upgrade History

Percona

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. for lib in $(psql -qtA pgbench -c"select extname||'.so'

C++ 81
article thumbnail

The Magic of PITR, pg_upgrade, and Logical Replication When Used Together for PostgreSQL Version Upgrades

Percona

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Also, it is a helpful method for version upgrades since the target database can run on a different (minor or major) PostgreSQL version. to PostgreSQL v15.4.

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

Site-Speed Topography

CSS Wizardry

I can see from the screenshot above that TTFB is my most stable metrics—no one page appears to have particularly expensive database queries or API calls on the back-end. The whole point of the exercise that follows is to allow me to move quickly, spotting patterns from afar, and not having to do any slow or meticulous work yet.

Speed 292
article thumbnail

PostgreSQL Parameters: Scope and Priority Users Should Know

Percona

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

article thumbnail

Deprecated features to take out of your toolbox – Part 3

SQL Performance

Let's create a simple database with a few tables: CREATE DATABASE BadIdeas ; GO. name , [ Column ] = c. name , [ Data Type ] = TYPE_NAME ( c. system_type_id <> c. THEN N' (' + TYPE_NAME ( c. columns AS c INNER JOIN sys. objects AS o ON c. [ USE BadIdeas ; GO.

C++ 58
article thumbnail

The top 5 reasons to run your own database benchmarks

HammerDB

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

article thumbnail

How to Assess MySQL Performance

HammerDB

Among the different components of modern software solutions, the database is one of the most critical. Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. We will not concern ourselves with the raw throughput of workload.