Why limit max-select-series?

[ezquat]

I’m interested in configuring my database to fail queries that would use too much memory or other resources or are otherwise infeasible, to reduce the chances that one user can take down the service for others.

I’m curious about the max-select-series parameter: Why would someone set this parameter? Is the number of series read in a query an indicator of how much memory would be used? Is the “series selected” a meaningful number for the “dangerousness” of a query?

[Anaisdg]

Hello @ezquat,
Yes, that’s right! For example to prevent you from querying all the data in your database (this was especially relevant in 1.x where users prone to using queries like "Select * from “mymeasurement” .