3 ms·
Can some one ELI5 why logging with loki is better than using a database like sqlite or postgresql.
by wanderingmind 2y ago
Can some one ELI5 why logging with loki is better than using a database like sqlite or postgresql.
- nijave 2y agoLog workload tends to be OLAP so an OLTP isn't very well optimized for the use case. Usually you can relax consistency and sometimes even partition tolerance to get something cheaper/faster https://en.wikipedia.org/wiki/CAP_theorem https://en.wikipedia.org/wiki/CAP_theorem
- fire_lake 2y agoLog data is often massive so you don’t want to be paying for a gigantic Postgres instance for storage. Logs also do not get updated, so the transactionality of Postgres is wasted.
- hckr1292 2y agoScalability and cost -- Loki stores the the actual log data on S3 and only keeps an index of a few fields. Log queries that can then efficiently target the (hopefully small) set of files containing the data and loki can re-parse those specific files from S3 to display the log results.