SF Meetup Report: Helicone's Migration from Postgres to ClickHouse for Advanced LLM Monitoring
Blog post from ClickHouse
ClickHouse hosted a "ClickHouse and AI - A Summer Meetup" event where Justin Torre from Helicone.ai shared their experience of using ClickHouse for Large Language Model (LLM) observability. Initially, Helicone used Postgres but faced scaling challenges with its dashboards, particularly with aggregation calls that took over 30 seconds to complete. The team migrated to ClickHouse, which provided impressive results, slashing dashboard query times from over 100 seconds to just 0.5 seconds. This migration showcased ClickHouse's efficiency and aligns with Helicone's commitment to open-source. The switch also allowed for the creation of a dual-insertion approach to populate both Postgres views and ClickHouse tables simultaneously. Justin appreciated the support from the ClickHouse team, which helped solve issues efficiently.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| LLM | 6 | 2,871 | 337 | 112 | +58% |
| Observability | 3 | 1,322 | 241 | 84 | -7% |
| Real-time | 2 | 2,440 | 626 | 177 | +28% |
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.