Hello, I have seen similar issues online but it seems that there are no answers at all.
We have been running the codes, and the last part is
I am not sure if our tables are consider big. The total size of the database is about 1.5TB and the code loads the bigger tables of around 2 billion lines.
The code is stuck in
Creating internal concept counts table at 33% for 36 hours. But postgreSQL query monitor says the code is still loading IO from the harddisc, so I do not think it is frozen but it just takes a lot of time to load?
Starting concept set diagnostics Instantiating concept sets |======================================================================| 100% Creating internal concept counts table |======================= | 33%
I am just curious who does the usual analysis - how long does
Creating internal concept counts table take? It seems ours are oddly long but I do not dare to stop the query.