ClickHouse introduces lazy materialization for faster, leaner queries

April 22, 2025, 1:21 pm

ClickHouse has unveiled its “lazy materialization” feature designed to cut down data reads and drastically reduce memory usage during query execution on enormous tables. This smart optimization reads only the demanded columns, slashing query times significantly and proving a robust enhancement for modern columnar databases.


simonwillison.net / ClickHouse gets lazier (and faster): Introducing lazy materialization

ClickHouse gets lazier (and faster): Introducing lazy materialization Tom Schreiber describe's the latest optimization in ClickHouse, and in the process explores a whole bunch of interesting characteristics of columnar datastores generally. As I understand it, the new "lazy materialization" feature...

clickhouse.com / ClickHouse gets lazier (and faster): Introducing lazy materialization

Comments


permalink / 2 stories from 2 sources in 37 hours ago #bigdata #software #analytics #datainfrastructure #clickhouse #database #performanceoptimization #sql #clickhouse #databases




More Top Stories...


Google Gemini court reveal shows explosive user growth

In a courtroom disclosure amid antitrust inquiries, internal data revealed that Google’s AI chatbot Gemini now boasts 350 million monthly active users. The revelation underscores the rapid adoption of Google’s AI offerings and intensifies the scrutiny over its market power. More...


OpenAI eyes purchase of Google Chrome business

In a move that might make industry insiders raise an eyebrow, OpenAI has expressed its willingness to acquire Google’s Chrome browser if the tech giant is forced to divest. This bold declaration underscores OpenAI’s ambition to expand its ecosystem while playfully challenging the status quo in the tech world. More...


Perplexity’s Bold Move Against Google’s Monopolistic Dealings

Perplexity’s chief business officer Dmitry Shevelenko has taken a defiant stance amid legal scrutiny over Google’s alleged restrictive deals. Subpoenaed to testify in a trial on Google’s search monopoly, he seized the chance to pitch the audacious idea of buying Chrome, criticizing tactics that stifle his company’s AI distribution. More...


OpenAI broadens access to its upgraded image generator

OpenAI is extending its cutting-edge image generation technology to developers by releasing it via API. The upgrade, famous for its Studio Ghibli-inspired visuals, will now empower other platforms and apps to integrate this feature directly, marking another bold step in the AI creative revolution. More...


Discord leadership shakeup fuels executive transition

In a major internal shakeup, Discord’s co-founder Jason Citron is stepping down as CEO after 13 years, making way for former Activision Blizzard exec Humam Sakhnini. This leadership change marks a pivotal moment for the platform as it navigates the heightened expectations of its evolving digital landscape. More...



Disclaimer: The information provided on this website is intended for general informational purposes only. While we strive for accuracy, we do not guarantee the completeness or reliability of the content. Users are encouraged to verify all details independently. We accept no liability for errors, omissions, or any decisions made based on this information.