AI metrics via PG: Rework the CH ingestion logic (buffer)

Problem

Proposal

As part of #474469 (closed):

• Rework the CH ingestion logic (buffer) to allow pushing data optionally to the new table