Agree - what would you need to see in PostgreSQL / TimescaleDB to enable you to switch from Big Query? We are all ears :-)
"infinite scalability" is something we are aiming for in our new vision for Timescale Cloud:
https://blog.timescale.com/blog/announcing-the-new-timescale...
We are not there today, but we are making progress.
Any other feedback - please let us know :-)