P99Conf's resource offers insights, tutorials, and resources for software developers and engineering leaders. Readers can learn about software engineering practices, system reliability, and distributed systems. With articles, talks, and case studies, P99Conf provides  guidance and expertise for building and managing high-performance systems.

P99 Conf

Coralogix migrated their metadata store from PostgreSQL to ScyllaDB, achieving a 349x performance improvement by reducing query processing time from 30 seconds to 86 milliseconds. The migration involved redesigning data models for NoSQL, implementing bloom filter chunking strategies, and optimizing partition keys. Despite challenges with data modeling and EBS storage decisions, the team successfully deployed a 3-node ScyllaDB cluster handling 10K writes per second with sub-millisecond P99 latency, processing terabytes of Parquet metadata for their observability platform.

Migrating from Postgres to ScyllaDB, with 349X Faster Query Processing

<p>I wonder what kind of performance gain would be possible with Postgres but after redesigning the database. How much of the gain was related to changing the database and how much to changing the data model.</p>


<p>So is there any reason to not switch?</p>
