article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning?

Tuning 52
article thumbnail

Percona Database Performance Blog 2018 Year in Review: Top Blog Posts

Percona

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

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

How to use Server Timing to get backend transparency from your CDN

Speed Curve

Looking at the industry benchmarks for US retailers , four well-known sites have backend times that are approaching – or well beyond – that threshold. Pagespeed Benchmarks - US Retail - LCP When you examine a waterfall, it's pretty obvious that TTFB is the long pole in the tent, pushing out render times for the page.

Servers 57
article thumbnail

40+ Best Web Development Blogs of 2018

KeyCDN

Subjects like version control, crowdfunding, database selection and code editor choices are essential to efficient modern workflows, and this is a good place to start learning about them. Visit website 14. CSSWizardy CSSWizardy is a good place to learn about scalable CSS practices and robust coding in general. Visit website 19.

article thumbnail

Nutanix AES: Performance By Example.

n0derunner

How to reduce database restore time by 50%. During.Next 2018 in London, Nutanix announced performance improvements in the core-datapath said to give up to 2X performance improvements. I am using X-Ray to simulate a 1TB data restore into an existing database. Here’s a real-world example of that improvement in practice.

article thumbnail

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. Is MongoDB an open source NoSQL database?

article thumbnail

Average Page Load Times for 2020 – Are you faster?

MachMetrics

Similar to our article Average Page Load Times for 2018 , we’ll go over the averages for metrics and help you determine if your site is faster or slower than average. It is typically reduced via server-side optimizations, such as enabling caching and database indexes. Source: ThinkWithGoogle. seconds on desktop and 2.59