article thumbnail

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Scalegrid

In our previous posts in this series, we spoke at length about using PgBouncer and Pgpool-II , the connection pool architecture and pros and cons of leveraging one for your PostgreSQL deployment. Performance Testing. For good measure, we ran the same tests without a connection pooler too. Testing Conditions.

article thumbnail

Comparing PostgreSQL DigitalOcean Performance & Pricing – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

PostgreSQL DigitalOcean Performance Test. In order to see which DBaaS provides the best PostgreSQL hosting performance on DigitalOcean, we are comparing equivalent plan sizes between ScaleGrid PostgreSQL on DigitalOcean and DigitalOcean Managed Databases: ScaleGrid PostgreSQL. PostgreSQL Benchmark Setup. Benchmark Tool.

Database 230
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

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

High Scalability

Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. SOA architecture based on REST APIs. Edge caching.

article thumbnail

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

Adrian Cockcroft

In 1991 I wrote a white paper on performance that was widely read, and in 1993 (with help from Brian Wong) that got me a job in the USA, working alongside Brian for Mike Briggs in technical product marketing. Paul Reithmuller was yet another imported Australian engineer who did amazing work.

Tuning 52
article thumbnail

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Plotting the percent performance loss vs syscall rate per CPU, for my microbenchmark: Applications that have high syscall rates include proxies, databases, and others that do lots of tiny I/O.

article thumbnail

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Plotting the percent performance loss vs syscall rate per CPU, for my microbenchmark: Applications that have high syscall rates include proxies, databases, and others that do lots of tiny I/O.

article thumbnail

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . For anyone benchmarking MySQL with HammerDB it is important to understand the differences from sysbench workloads as HammerDB is targeted at a testing a different usage model from sysbench.