Reduce container count in self-hosted

[OldBucFan]

Problem Statement

Our upgrade from 22.8.0 to 23.11.1 effectively doubled the number of containers running, requiring an increased memory allocation and thus higher cost of ownership.

Solution Brainstorm

Could Snuba and Sentry jobs be consolidated to run on a few containers vs. dedicated per job.

[rhuddleston]

Possibly an option so the snuba consumer or sentry consumer jobs can be optionally combined and consume multiple events in a single container?

[azaslavsky]

We have some long term plans to do this, but it's not on the docket until at least February of next year. I'll keep this issue open for now.

[aldy505]

This is a duplicate of #2539 and #1763

[azaslavsky]

Good point - will roll this issue into those and mark as a dupe.

[rhuddleston]

snuba issue: getsentry/snuba#1670