Menghindari bottleneck dari ribuan koneksi langsung ke Postgres.

pgbouncer.ini

[databases]
explorer = host=localhost port=5432 dbname=explorer

[pgbouncer]
listen_port = 6432
listen_addr = 0.0.0.0
auth_type = md5
pool_mode = transaction
max_client_conn = 1000
default_pool_size = 100

change connection into

const client = drizzle({
  connectionString: "postgres://user:pass@localhost:6432/explorer"
});

instead of

import 'dotenv/config';
import { drizzle } from 'drizzle-orm/bun-sql';
import { SQL } from 'bun';

const client = new SQL(process.env.DATABASE_URL!);
export const db = drizzle({ client });

test

psql -h localhost -p 6432 -U user explorer

before

import { drizzle } from 'drizzle-orm/node-postgres';
import { Pool } from 'pg';

const pool = new Pool({
  connectionString: process.env.DATABASE_URL,
});

export const db = drizzle(pool);

after

import { drizzle } from 'drizzle-orm/node-postgres';
import { Pool } from 'pg';

const pool = new Pool({
  connectionString: process.env.DATABASE_URL ?? 'postgres://user:pass@localhost:6432/explorer',
  // Optional: tambahkan idleTimeoutMillis, max, dll
});

export const db = drizzle(pool);

localhost:5432

localhost:6432

jalankan salah satu query / migrate

bun run migrate

monitoring koneksi di PgBouncer:

SHOW POOLS;
SHOW STATS;