Trivial queries against tokens_ethereum.balances_daily run for 30 mins and fail with an “memory” error on the backend. For example, would expect that the query:
SELECT * FROM tokens_ethereum.balances_daily LIMIT 100should come back rather quickly. However will run for 30mins and fail. Adjusting this query with a WHERE to reduce the dataset will also fail. So seems like this is something pathological about this table in particular.
We are querying other large tables such as {chain}.transactions without any problems.
Please authenticate to join the conversation.
Open
Bugs
About 1 year ago

Jonathan Shore
Get notified by email when there are changes.
Open
Bugs
About 1 year ago

Jonathan Shore
Get notified by email when there are changes.