4 ms·
> With all the new trials and customers, and an increase in larger websites trying our service, Plausible became much slower to use. (...) We moved from our Pos
by rmbyrro 4y ago
> With all the new trials and customers, and an increase in larger websites trying our service, Plausible became much slower to use. (...) We moved from our PostgreSQL database to ClickHouse
Had the impression they were monitoring up to a couple hundred websites at that time. Probably small ones.
I'm surprised Postgres was slowing them down. Maybe the queries or the database were not well optimized?
- zX41ZdbW 4y agoIf you need customizable reports (filtering and aggregating by any dimension), you cannot avoid scan over non-aggregated data. This is where you cannot optimize Postgres queries. Postgres becomes slow starting from just single million records.