I am running QuestDB 8.1.4 with default parameters via Docker. I can see the message Java Heap Space, 36, ERROR appearing frequently on the logs.

I want to calculate the standard deviation in a time window. QuestDB supports stddev as an aggregate function, but not as a window function. Is there any workaround for this or do I have to calculate client side?

I want to calculate the standard deviation in a time window. QuestDB supports stddev as an aggregate function, but not as a window function. Is there any workaround for this or do I have to calculate client side?

Now that QuestDB can generate tables directly in Parquet format I am trying to explore the data using pyarrow with this code:

I want to send data into QuestDB using Ruby and the ILP protocol. Browsing old docs, I saw you can connect via socket and compose the messages. I tried the code below and it works, but it seems fragile as escaping columns or using the wrong
time resolution sounds too easy. Do you know of any gems for this? I could always use the Postgresql protocol, but I prefer ILP for performance and for flexible schema.

We got a full disk in our server yesterday. We expanded the disk and restarted, but we are getting an error with one of the tables. Database is now instable, as it worked for a bit but we are getting the errors again in the log.

We had a single table with data for over 5K different customers. We decided to move instead to 5k tables, one per customer, as we seldom query data from multiple customers as we thought this should improve performance and would also make things cleaner.