/** @jsxImportSource https://esm.sh/react@18.2.0 */ import React, { useState, useMemo } from "https://esm.sh/react@18.2.0"; import { createRoot } from "https://esm.sh/react-dom@18.2.0/client"; function PostgreSQLParameterCalculator() { const instanceTypes = [ { name: 'db.r5.large', vCPU: 2, description: 'Small instance, 2 vCPUs' }, { name: 'db.r5.xlarge', vCPU: 4, description: 'Medium instance, 4 vCPUs' }, { name: 'db.r5.2xlarge', vCPU: 8, description: 'Large instance, 8 vCPUs' }, { name: 'db.r5.4xlarge', vCPU: 16, description: 'Very large instance, 16 vCPUs' } ]; const [selectedInstance, setSelectedInstance] = useState(instanceTypes[0]); const [numberOfDatabases, setNumberOfDatabases] = useState(2); const calculateParameters = (instance, dbCount) => { const { vCPU } = instance; const max_replication_slots = Math.max( 10, dbCount + 2, vCPU * 2 ); const max_wal_sender = Math.max( max_replication_slots, 10, vCPU ); const reserve = 2; const max_logical_replication_workers = Math.max( max_replication_slots + reserve, 4, Math.floor(vCPU / 2) ); const autovacuum_max_workers = 3; const max_parallel_workers = Math.floor(vCPU / 2); const max_worker_processes = max_logical_replication_workers + autovacuum_max_workers + max_parallel_workers; const parameters = { max_replication_slots: { value: max_replication_slots, description: 'Maximum number of replication slots', recommendation: 'Should be 2+ more than number of databases' }, max_wal_sender: { value: max_wal_sender, description: 'Maximum concurrent WAL sender processes', recommendation: 'Must be at least equal to max_replication_slots' }, max_logical_replication_workers: { value: max_logical_replication_workers, description: 'Maximum logical replication workers', recommendation: 'Includes two reserve workers' }, max_worker_processes: { value: max_worker_processes, description: 'Total background worker processes', recommendation: 'Combines replication, autovacuum, and parallel workers' } }; return parameters; }; const parameters = useMemo(() => calculateParameters(selectedInstance, numberOfDatabases), [selectedInstance, numberOfDatabases] ); return (

🔧 RDS PostgreSQL Parameter Calculator

Instance Type {selectedInstance.description}

Number of Databases setNumberOfDatabases(Number(e.target.value))} style={{ width: '100%', padding: '8px', fontSize: '0.9rem', boxSizing: 'border-box' }} />

Recommended Parameters

{Object.entries(parameters).map(([name, param]) => (

{name}

{param.value}

{param.description}

))}

Blue/Green Deployment Notes

Parameters are dynamically calculated based on instance vCPUs and database count
Calculations ensure proper scaling for replication and background processes
Always validate these recommendations in your specific environment

); } function client() { createRoot(document.getElementById("root")).render(); } if (typeof document !== "undefined") { client(); } export default async function server(request: Request): Promise { return new Response(` RDS PostgreSQL Parameter Calculator

`, { headers: { "content-type": "text/html" } }); }

BaronVonLeskis