performance Archives - 2ndQuadrant

Posts

Webinar: KNN Indexing in PostgreSQL [Follow Up]

May 4, 2020/0 Comments/in Webinars /by Bilal Ibrar

K-nearest neighbor is a proximity algorithm to find data in order of distance. Typically, this data cannot be indexed in advance, as both the centroid and the data can be in constant motion. PostgreSQL provides efficient searching algorithms for finding proximity data on the fly, including unique, high-performance indexing options. For a deeper understanding of […]

Webinar: State of Full Text Search in PostgreSQL 12 [Follow Up]

March 13, 2020/0 Comments/in Webinars /by Liaqat Andrabi

Increasing robustness of Full Text Search in PostgreSQL allows applications like Search Engines and Text Editing Software to utilize native support without the need for 3rd party search tools. The release of PostgreSQL 12 added new capabilities to Full Text Search in terms of rich features, performance improvements, efficiency and more. 2ndQuadrant hosted a webinar […]

Researching PostGIS slowness (2019 edition)

February 27, 2020/2 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

Just as last year was ending, one of our long-time customers came to us because one of their long-existing PostgreSQL queries involving PostGIS geometry calculations was much slower for specific values. We researched the problem and found out how to solve it; read on! What we found as the cause of the problem will surprise […]

Webinar: PostgreSQL Partitioning [Follow up]

October 28, 2019/1 Comment/in 2ndQuadrant, PostgreSQL, Webinars /by Bilal Ibrar

With the recent release of PostgreSQL 12, there’s been a lot of interest in the latest version and by popular demand, the team at 2ndQuadrant organized a live webinar on “PostgreSQL Partitioning”. The webinar was hosted by Simon Riggs, CTO 2ndQuadrant, who gave an overview of PostgreSQL partitioning features and how they play a key […]

PostgreSQL 12: A Few Special-Case Performance Enhancements

September 24, 2019/2 Comments/in 2ndQuadrant, John’s PlanetPostgreSQL /by John Naylor

With every new release of PostgreSQL, there are a range of performance enhancements. Some are system-wide and affect every user, but most are highly specific to a certain use case. In this post, I am going to briefly highlight three improvements in PG12 that speed up certain operations. 1. Minimal decompression of TOAST values TOAST […]

Sequential UUID Generators on SSD

March 8, 2019/0 Comments/in 2ndQuadrant, Tomas' PlanetPostgreSQL /by Tomas Vondra

After I shared the sequential UUID benchmarks a couple of weeks ago, one of the points raised in feedback was the choice of the storage space. I’ve intentionally used a fairly weak storage system (RAID10 on three 7.2k SATA drives) because I wanted to demonstrate the benefits. But a couple of readers suggested using SSDs might significantly reduce […]

PostgreSQL Meltdown Benchmarks

March 4, 2018/0 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

Two serious security vulnerabilities (code named Meltdown and Spectre) were revealed a couple of weeks ago. Initial tests suggested the performance impact of mitigations (added in the kernel) might be up to ~30% for some workloads, depending on the syscall rate. Those early estimates had to be done quickly, and so were based on limited […]

When autovacuum does not vacuum

April 19, 2017/8 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A few weeks ago I explained basics of autovacuum tuning. At the end of that post I promised to look into problems with vacuuming soon. Well, it took a bit longer than I planned, but here we go. To quickly recap, autovacuum is a background process cleaning up dead rows, e.g. old deleted row versions. […]

Autovacuum Tuning Basics

March 2, 2017/11 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A few weeks ago I covered the basics of tuning checkpoints, and in that post I also mentioned that the second common source of performance issues is autovacuum (based on what we see on the mailing list and at our customers under support). So let me follow-up on that with this post about the basics […]

Benchmark on a Parallel Processing Monster!

February 28, 2017/8 Comments/in David's PlanetPostgreSQL /by David Rowley

Last year I wrote about a benchmark which I performed on the Parallel Aggregate feature that I worked on for PostgreSQL 9.6. I was pretty excited to see this code finally ship in September last year, however something stood out on the release announcement that I didn’t quite understand: Scale Up with Parallel Query Version 9.6 […]