# Resolving a year-long ClickHouse® lock contention

DevFeed: [Resolving a year-long ClickHouse® lock contention](<https://devfeed.tech/articles/resolving-a-year-long-clickhouse-lock-contention-18443.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/clickhouse-lock-contention>)

Author: Jordi Villar

Published: 2023-10-30T00:00:00Z

Content type: article

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [engineering-excellence](<https://devfeed.tech/tags/engineering-excellence.md>), [performance](<https://devfeed.tech/tags/performance.md>)

## AI overview

This article describes resolving a ClickHouse lock contention problem that had stumped the team for over a year, resulting in a reported 5x performance improvement.

## Source excerpt

Here's how we fixed a problem that had stumped us for over a year and saw a 5x performance improvement in the process.