Haɗin gida yana sake amfani da ƙaramin jerin haɗin gida tsakanin mutane da yawa na buƙatun client, maimakon buɓugi haɗi sabon ga kowane buƙatu. Haɗin gida na PostgreSQL mai tsada (kowannensu aiki daban ya amfani da alaƙar kuɗi mai yawa), don haka haɗin gida shi ne dole ne don aikin jiya da girma karkashin nauyin aiki. PgBouncer shi ne ma'aikacin haɗin gida na yau da kullun.
Matsalar: haɗin gida na PostgreSQL sun kasua
Each PostgreSQL connection = a separate OS PROCESS, using ~5-10MB of memory.
✗ Opening a connection has overhead (process creation, auth, setup)
✗ Many connections (e.g. 1000s from a busy app) → huge memory use, contention
✗ Postgres has a max_connections limit (often ~100); exceeding it = errors
→ Opening/closing a connection per request, or holding thousands open, doesn't scale.
