HI All, very much a newbie when it comes to databases. I am trying to store stock market data in a TimeScaleDB running in a docker container on a linux server. The software package that i use wants me to store each stock market ticker symbol in its own table. I am parsing through a list of 500 stocks, create a table, create an index on the table and turn the table into a hypertable, then i write the data (approx 1M datapoints). I repeat this for all tickers. After about 15 tables, in the middle of a write operation, the database goes into recovery mode… Anybody has an idea what i am doing wrong?
Eventually I want 10.000 tables Is this realistic?