Does this mean we can have scale-to-zero Postgres? One pain we have with Clickhouse Postgres is that we have to pay for dev/staging databases that receive no traffic most of the time.

Yes, we're working on integrating Xata tech into ClickHouse Managed Postgres. That includes scale-to-zero and quick wake-up times.