BigQuery is a monster at scale on loading big volumes of data but processing that output real-time into an AI model requires ...

Of course, if your PG server is running on a virtual machine, increasing hardware resources can also be an emergency option.