
Faceting large result sets in PostgreSQL
Learn how to implement faceting in your PostgreSQL-based applications to narrow search results - very attractive for users.
974 articles on Performance.

Learn how to implement faceting in your PostgreSQL-based applications to narrow search results - very attractive for users.

Vercel's edge-first serverless platform accelerates development with Preview Deployments and delivers production performance at scale, as proven by The Washington Post's seamless US Midterm Elections coverage.



After Shopify went all-in on React Native, we had to find a way to confirm our mobile apps are fast. The solution is an open-source @shopify/react-native-performance library, which measures rendering times in React Native apps.

Historical announcement for Edge Config, a globally replicated data store for low-latency reads from Vercel Functions and Routing Middleware.

Prioritizing performance when building our web apps improves the user experience and helps ensure they can be used by as many people as possible. In this article, Michelle Barker will walk you through some of the front-end optimization tips to keep our Vue apps as efficient as possible.

Cloudflare did the measurements to prove we’re the fastest developer platform, beating out all the other competition.

EXPLAIN (ANALYZE, BUFFERS) output is hard to get for a parameterized statement in PostgreSQL. With a few tricks we can get EXPLAIN output.

Improve queries in PostgreSQL - it is not always possible to rewrite OR to UNION in a query. Find out when it is safe to do manually.

How do you index in a data warehouse? See the advantages and disadvantages of btree (AKA B-tree) and BRIN indexes in PostgreSQL.

In October, we experienced four incidents that resulted in degraded performance across GitHub services. This report also sheds light into an incident that impacted Codespaces in September.

Needing to deliver faster and more reliably while managing a growing number of contributors and a more complex codebase seems like the fate of every hyper-growth tech company. For platform teams, the challenge is not any different. How can we quickly roll out and increase the adoption of new technologies safely with a growing codebase and organization?

Introducing Turbopack, the Rust-based successor to Webpack. A high-performance bundler for React Server Components and TypeScript codebases.

In this blog-post we demonstrate how hosting and combining multiple server-side rendered micro-frontends on Cloudflare Workers offer a highly scalable, high performance solution to these problems

Updates getting slower is a frequent complaint of PostgreSQL users. What is behind it and how can I avoid slow updates?

Announcing Vercel OG Image Generation, a new library for generating dynamic social card images.

Announcing support for sending Early Hints from your Cloudflare Pages projects

In September, we experienced one incident that resulted in degraded performance across GitHub services. We also experienced one incident resulting in significant impact to Codespaces. We are still investigating that incident and will include it in next month’s report. This report also sheds light into an incident that impacted Codespaces in August and an incident that impacted Actions in August.

Find out how basement.studio balanced performance, entertainment, and reliability for MrBeast's new storefront.

Cloudflare Stream now supports live streaming over WebRTC to unlimited concurrent viewers, using open standards WHIP and WHEP, with zero dependencies or client SDKs necessary.

You don’t need a framework for everything, but if you use one, this article will help you use it in the most performant way.

API Shield customers can save, update, and monitor the performance of API endpoints

The GitHub Actions team has done lots of work to improve the performance and resource consumption of Actions on GHES in the past year.


Developers all over the world are using GitHub Copilot to help speed up their development and increase developer productivity. With GitHub Copilot available to developers everywhere, we’ve found some fun and useful examples of how developers can use GitHub Copilot for things you may not be thinking about.

A tour of recent work to re-engineer Git’s garbage collection process to scale to our largest and most active repositories.

Vercel natively supports and extends Next.js 12.3, allowing teams to improve their workflow and iterate faster.

Meet “Smart Interface Design Patterns Checklists”, a deck of 166 checklist cards to help you design and build better interfaces, faster. With accordions, mega-drop-downs, data tables, carousels, and everything in-between.

How Shopify scaled our Server Pixels service to increase its event processing performance by 170%.

How we made your Vercel Analytics data more actionable to drive performance for your application.

Next.js Conf 2022: Presented by Vercel

Some of the most common questions asked when it comes to work with performance are, How do you convince stakeholders that improving the performance of your project is actually worth the investment? How can you prove that the work is necessary to begin with? Or prove that you have shipped improvements? And what is the impact of certain changes on users in different scenarios?

Watch Shopify's tech talent tackle topics ranging from virtual machines, performance improvements, and investing in open source teams at RailsConf 2022

What happens when your distributed service has challenges with stampeding herds of internal requests? How do you prevent cascading failures between internal services? How might you re-architect your workflows when naive horizontal or vertical scaling reaches their respective limits? These were the challenges facing Slack engineers during their day-to-day development workflows in 2020. Multiple int

Shopify’s React Native Foundations team created FlashList, a fast and performant list component that can be swapped into your project with minimal effort.

In React, we don't update the DOM directly, we tell React what we want the DOM to look like, and React tackles the rest. But how exactly does it do this? In this tutorial, we'll unpack exactly when and why React re-renders, and how we can use this information to optimize the performance of our React apps.

I had this conversation over and over before I really understood it. It goes: “X language can be as fast as a compiled language because it has a JIT compiler!” “Wow! It’s as fast as C?” “Well, no, we’re working on it. But in theory, it could be even FASTER than C!” “Really? How would that work?” “A JIT can see what your code does at runtime and optimize for only that. So it can do things C can’t!”

Identify, compare, analyze and fix your Core Web Vitals scores to boost web performance of your sites. These tools will help you to do just that.

Learn more about Terminal’s latest updates which enable our users to reach more customers globally, start accepting in-person payments faster, and deliver a frictionless checkout experience for more use cases.

In July, we experienced one incident that resulted in degraded performance for Codespaces. This report also acknowledges two incidents that impacted multiple GitHub.com services in June.

Ebun breaks down how she used a not-so-great performance review to set clear development goals for herself and increase alignment with her lead, ultimately leading to a successful next review.

Optimizing the size of images can have a bigger impact on performance than all other areas combined. In this article, Louis Lazaris covers different tools available for reducing the size of images. You might already know that Smashing Magazine has published the book Image Optimization by Addy Osmani, which covers this topic in full detail. But consider this post a compliment to the book, as this w

gexec PostgreSQL poweruser practice: Learn how to use the gexec command and the `||` operator to get the best results out of your psql.

Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables

Strapi is an open-source headless content management system (CMS) built with Node.js, and Hugo builds sites pretty fast, with average site builds completed in a second or less. In this tutorial, Zara Cooper explains how to use Strapi’s Internationalization feature to create content in multiple languages. You’ll also learn how to create a Hugo site that consumes localized content from Strapi.

In this post, we describe how we modified the Linux kernel to optimize for both low latency and high throughput concurrently

Monorepo performance can suffer due to the sheer number of files in your working directory. Git’s new builtin file system monitor makes it easy to speed up monorepo performance.

Hertzbleed is a brand-new family of side-channel attacks that monitors changes on CPU frequency

Execute custom logic at the moment of request, pushing personalization to the edge with exceptional performance.

We’re excited to share that Cloudflare has the fastest provider in 1,290 of the top 3,000 most reported networks, up from 1,280 even one month ago during Platform Week

During a time of uncertainty due to the global pandemic, a time when everyone was more online than ever before, Cloudflare, Google, and Shopify all came together to build and test Early Hints

‘My home network is faster than my corporate network’’ is a common complaint of the employees returning to work. Legacy MPLS based networks were not built to support the shift in the applications.

Looking for ways to test your product faster? Most of startup founders start a project with visions of a perfect product in their head. However, in reality, a well-performing product will likely look way different than an initial concept. Instead of seeking perfection from the outset, beginning with a Minimum Viable Product (MVP) is the smartest route to success. In this article, Sergey Krasotin u

If you’ve been thinking about Zero Trust or SASE, Cloudflare One Week will demonstrate why Cloudflare One is one of the most complete SASE offerings in the market, with some of the best performance, and why it will only continue to improve

Teams and GHEC customers can now create blazing fast codespaces, even for your largest and most complex projects.

Do we, as users and designers, really need to assess typefaces and find out how they perform? Is it necessary? Well, whatever your thoughts are, in 2022, with a mass of typefaces available and 100s of years of designing and manufacturing typefaces, it is time to consider this topic. In this article, we will be discussing ways to test typefaces and other typographic issues. Though this article is s

CI/CD and workflow automation are native capabilities on GitHub platform. Here’s how to start using them and speed up your workflows.

In this article, we will be discussing how typefaces work, ways to test typefaces, and broader typographic issues. Though this article is slightly high-end and academic, fear not. The content will be of interest, especially for committed typeface designers and typographers. If you like complex issues and problems, this is for you.

TL;DR With Spotify’s rapid global expansion to more than 180 countries, it’s critical that the infrastructure of user forecasts catch up to business needs. As the business evolves, we need an infrastructure in place that can satisfy the varying needs of stakeholders across the company. To enable fast iterations and facilitate model training, we built a system that allows user forecasts to run both