Join us for a virtual meetup on Zoom at 8 PM, July 31 (PDT) about using One Time Series Database for Both Metrics and Logs 👉🏻 Register Now

Skip to content
On this page
Biweekly
December 18, 2024

Optimized Memory, Accelerated Queries, and a New Log View! Greptime Biweekly Report

A recap of the past 2 weeks progress and changes happened on GreptimeDB.

Summary

Together with our global community of contributors, GreptimeDB continues to evolve and flourish as a growing open-source project. We are grateful to each and every one of you.

Below are the highlights among recent commits:

  • Optimize memory usage during intensive log ingestion

  • Introducing the new SKIPPING index syntax

  • Introducing CURSOR statement support for PostgreSQL

  • Reducing cache size in last-point query scenarios

  • Reducing IO wait time using prefetching index files from the object store

  • Introducing the new Log View in the dashboard UI

Contributors

For the past two weeks, our community has been super active with a total of 96 PRs merged. Of these, 4 PRs were contributed by 2 individual contributors, with many more pending to be merged.

A big THANK YOU to all our members and contributors! It is people like you who are making GreptimeDB a great product. Let's build an even greater community together.

Highlights of Recent PRs

db#5135 db#5157 Reduce memory usage under log ingestion

We've conducted a new benchmark under the logging scenario and made major performance improvements upon profiling results. By avoiding holding file caches and memtables during compaction, memory usage is significantly reduced under heavy log ingestion and frequent compaction, from 5.5GB to 500MB at an average level.

db#5095 Reduce cache size in last-point query scenarios

By referencing a new empty batch instead of the old last-row batch, we reduce the cache size in last-point query scenarios from 1GB to 8.3MB under TSBS test cases.

db#5145 db#5146 Reduce IO wait time by prefetching index files

Our index files are stored along with data files in the object store. We've made some improvements using prefetching techniques when queries fall to the object store, reducing wait time from 40ms to 10ms.

db#5155 db#5177 Introducing SKIPPING index syntax

Besides the inverted index and the full-text index, we're developing a new SKIPPING index (implemented using bloom filter) for text searching and matching acceleration. This new type of index will largely reduce the cost of building the full-text index and achieve a similar RT in query scenarios. See the tracking issue here for bloom filter implementation: db#5176.

db#5081 db#5094 Introducing CURSOR statement support for PostgreSQL

Introduce initial support for PostgreSQL's CURSOR statement. We're hoping to be a PostgreSQL foreign data wrapper-compatible server after this series of PRs.

db#5172 Add Log View in GreptimeDB dashboard UI

In the latest release of our integrated dashboard, we introduced the new Log View, which is a new convenient way to observe and search for logs in the database. We're continuously improving the Log View to be a powerful log analysis tool.

More details: Introducing Log View in GreptimeDB Dashboard UI

Good First Issue

db#5120 Implement various vector operation functions

  • Keywords: Vector

  • Difficulty: Simple


About Greptime

Greptime offers industry-leading time series database products and solutions to empower IoT and Observability scenarios, enabling enterprises to uncover valuable insights from their data with less time, complexity, and cost.

GreptimeDB is an open-source, high-performance time-series database offering unified storage and analysis for metrics, logs, and events. Try it out instantly with GreptimeCloud, a fully-managed DBaaS solution—no deployment needed!

The Edge-Cloud Integrated Solution combines multimodal edge databases with cloud-based GreptimeDB to optimize IoT edge scenarios, cutting costs while boosting data performance.

Star us on GitHub or join GreptimeDB Community on Slack to get connected.

community
memory
UI

Join our community

Get the latest updates and discuss with other users.