\n 🔧 RDS PostgreSQL Parameter Calculator\n

\n \n

\n Instance Type\n \n \n {selectedInstance.description}\n \n

\n \n

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

\n\n

\n Recommended Parameters\n

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

\n {name}\n

\n {param.value}\n

\n {param.description}\n

\n ))}\n

\n\n

\n Blue/Green Deployment Notes\n

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

\n\n \n

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

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}","deleted","label","children",[],[99],"files",[151],"counts",{"_173":32,"_174":175,"_176":32,"_177":32},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_103":152,"_95":99,"_153":115,"_154":-5,"_155":139,"_156":138,"_157":117,"_105":182,"_100":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":183},["D",1738513259277],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":192,"_180":197,"_200":201,"_237":238,"_248":-7,"_249":32,"_250":22},{"_103":104,"_95":96,"_105":193,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":115,"_116":117,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":194,"_133":195,"_136":196,"_148":22},["D",1746231541716],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_100":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},{"_103":152,"_95":99,"_153":115,"_154":-5,"_155":139,"_156":138,"_157":117,"_105":198,"_100":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":199},["D",1738513259277],[99],"history",[202,204,209,214,219,224,229,233],{"_103":152,"_155":139,"_153":115,"_95":99,"_162":163,"_160":161,"_100":159,"_154":-5,"_105":203,"_156":138,"_165":-5},["D",1738513259277],{"_103":205,"_155":139,"_153":115,"_95":99,"_162":206,"_160":161,"_100":207,"_154":-5,"_105":208,"_156":159,"_165":-5},"3705cc56-27b4-11f0-aecd-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction PostgreSQLParameterCalculator() {\n const instanceTypes = [\n { \n name: 'db.r5.large', \n vCPU: 2, \n description: 'Small instance, 2 vCPUs'\n },\n { \n name: 'db.r5.xlarge', \n vCPU: 4, \n description: 'Medium instance, 4 vCPUs'\n },\n { \n name: 'db.r5.2xlarge', \n vCPU: 8, \n description: 'Large instance, 8 vCPUs'\n },\n { \n name: 'db.r5.4xlarge', \n vCPU: 16, \n description: 'Very large instance, 16 vCPUs'\n }\n ];\n\n const [selectedInstance, setSelectedInstance] = useState(instanceTypes[0]);\n const [numberOfDatabases, setNumberOfDatabases] = useState(2);\n\n const calculateParameters = (instance, dbCount) => {\n const { vCPU } = instance;\n \n // Calculate max_replication_slots\n // Ensure it's higher than the number of databases\n const max_replication_slots = Math.max(\n 10, // Minimum baseline\n dbCount + 2, // At least 2 more than number of databases\n vCPU * 2 // Consider instance size\n );\n\n // Calculate max_wal_sender\n // Must be at least equal to max_replication_slots\n const max_wal_sender = Math.max(\n max_replication_slots, // At least equal to replication slots\n 10, // Minimum baseline\n vCPU // Consider instance size\n );\n\n // Calculate max_logical_replication_workers\n // Must be at least max_replication_slots + reserve\n const reserve = 2; // As specified\n const max_logical_replication_workers = Math.max(\n max_replication_slots + reserve,\n 4, // Minimum baseline\n Math.floor(vCPU / 2) // Consider instance size\n );\n\n // Autovacuum workers typically 3 by default\n const autovacuum_max_workers = 3;\n\n // Parallel workers typically half of vCPU count\n const max_parallel_workers = Math.floor(vCPU / 2);\n\n // Calculate max_worker_processes\n // Sum of logical replication workers, autovacuum workers, and parallel workers\n const max_worker_processes = \n max_logical_replication_workers + \n autovacuum_max_workers + \n max_parallel_workers;\n\n // Construct parameters object with detailed descriptions\n const parameters = {\n max_replication_slots: {\n value: max_replication_slots,\n description: 'Maximum number of replication slots',\n recommendation: 'Should be 2+ more than number of databases'\n },\n max_wal_sender: {\n value: max_wal_sender,\n description: 'Maximum concurrent WAL sender processes',\n recommendation: 'Must be at least equal to max_replication_slots'\n },\n max_logical_replication_workers: {\n value: max_logical_replication_workers,\n description: 'Maximum logical replication workers',\n recommendation: 'Includes two reserve workers'\n },\n max_worker_processes: {\n value: max_worker_processes,\n description: 'Total background worker processes',\n recommendation: 'Combines replication, autovacuum, and parallel workers'\n }\n };\n\n return parameters;\n };\n\n const parameters = useMemo(() => \n calculateParameters(selectedInstance, numberOfDatabases), \n [selectedInstance, numberOfDatabases]\n );\n\n return (\n

🔧 RDS PostgreSQL Parameter Calculator

\n \n

\n Instance Type\n \n {selectedInstance.description}\n

\n \n

\n Number of Databases\n setNumberOfDatabases(Number(e.target.value))}\n style={{ width: '100%', padding: '5px' }}\n />\n

\n\n

Recommended Parameters

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

Parameter	Value	Description
{name}	\n {param.value}\n	\n {param.description}\n

\n\n

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

\n\n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",6,["D",1736785711539],{"_103":210,"_155":139,"_153":115,"_95":99,"_162":211,"_160":161,"_100":212,"_154":-5,"_105":213,"_156":207,"_165":-5},"37013c90-27b4-11f0-aecd-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction PostgreSQLParameterCalculator() {\n const instanceTypes = [\n { \n name: 'db.r5.large', \n vCPU: 2, \n description: 'Small instance, 2 vCPUs'\n },\n { \n name: 'db.r5.xlarge', \n vCPU: 4, \n description: 'Medium instance, 4 vCPUs'\n },\n { \n name: 'db.r5.2xlarge', \n vCPU: 8, \n description: 'Large instance, 8 vCPUs'\n },\n { \n name: 'db.r5.4xlarge', \n vCPU: 16, \n description: 'Very large instance, 16 vCPUs'\n }\n ];\n\n const [selectedInstance, setSelectedInstance] = useState(instanceTypes[0]);\n const [numberOfDatabases, setNumberOfDatabases] = useState(2);\n\n const calculateParameters = (instance, dbCount) => {\n const { vCPU } = instance;\n \n // Calculate max_replication_slots\n // Ensure it's higher than the number of databases\n const max_replication_slots = Math.max(\n 10, // Minimum baseline\n dbCount + 2, // At least 2 more than number of databases\n vCPU * 2 // Consider instance size\n );\n\n // Calculate max_wal_sender\n // Must be at least equal to max_replication_slots\n const max_wal_sender = Math.max(\n max_replication_slots, // At least equal to replication slots\n 10, // Minimum baseline\n vCPU // Consider instance size\n );\n\n // Calculate max_logical_replication_workers\n // Must be at least max_replication_slots + reserve\n const reserve = 2; // As specified\n const max_logical_replication_workers = Math.max(\n max_replication_slots + reserve,\n 4, // Minimum baseline\n Math.floor(vCPU / 2) // Consider instance size\n );\n\n // Autovacuum workers typically 3 by default\n const autovacuum_max_workers = 3;\n\n // Parallel workers typically half of vCPU count\n const max_parallel_workers = Math.floor(vCPU / 2);\n\n // Calculate max_worker_processes\n // Sum of logical replication workers, autovacuum workers, and parallel workers\n const max_worker_processes = \n max_logical_replication_workers + \n autovacuum_max_workers + \n max_parallel_workers;\n\n // Construct parameters object with detailed descriptions\n const parameters = {\n max_replication_slots: {\n value: max_replication_slots,\n description: 'Maximum number of replication slots',\n calculation: 'Take the highest of: a minimum of 10, two more than the number of databases, or twice the number of vCPUs',\n recommendation: 'Should be 2+ more than number of databases'\n },\n max_wal_sender: {\n value: max_wal_sender,\n description: 'Maximum concurrent WAL sender processes',\n calculation: 'Take the highest of: the number of replication slots, a minimum of 10, or the number of vCPUs',\n recommendation: 'Must be at least equal to max_replication_slots'\n },\n max_logical_replication_workers: {\n value: max_logical_replication_workers,\n description: 'Maximum logical replication workers',\n calculation: 'Take the highest of: replication slots plus two reserve workers, a minimum of 4, or half the number of vCPUs',\n recommendation: 'Includes two reserve workers'\n },\n max_worker_processes: {\n value: max_worker_processes,\n description: 'Total background worker processes',\n calculation: 'Sum of logical replication workers, autovacuum workers (typically 3), and parallel workers (half the vCPU count)',\n recommendation: 'Combines replication, autovacuum, and parallel workers'\n }\n };\n\n return parameters;\n };\n\n const parameters = useMemo(() => \n calculateParameters(selectedInstance, numberOfDatabases), \n [selectedInstance, numberOfDatabases]\n );\n\n return (\n

🔧 RDS PostgreSQL Parameter Calculator

\n \n

\n Instance Type\n \n {selectedInstance.description}\n

\n \n

\n Number of Databases\n setNumberOfDatabases(Number(e.target.value))}\n style={{ width: '100%', padding: '5px' }}\n />\n

\n\n

Recommended Parameters

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

Parameter	Value	Description	Calculation
{name}	\n {param.value}\n	\n {param.description}\n	\n {param.calculation}\n

\n\n

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

\n\n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",5,["D",1736785649519],{"_103":215,"_155":139,"_153":115,"_95":99,"_162":216,"_160":161,"_100":217,"_154":-5,"_105":218,"_156":212,"_165":-5},"36fcba26-27b4-11f0-aecd-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction PostgreSQLParameterCalculator() {\n const instanceTypes = [\n { \n name: 'db.r5.large', \n vCPU: 2, \n description: 'Small instance, 2 vCPUs'\n },\n { \n name: 'db.r5.xlarge', \n vCPU: 4, \n description: 'Medium instance, 4 vCPUs'\n },\n { \n name: 'db.r5.2xlarge', \n vCPU: 8, \n description: 'Large instance, 8 vCPUs'\n },\n { \n name: 'db.r5.4xlarge', \n vCPU: 16, \n description: 'Very large instance, 16 vCPUs'\n }\n ];\n\n const [selectedInstance, setSelectedInstance] = useState(instanceTypes[0]);\n const [numberOfDatabases, setNumberOfDatabases] = useState(2);\n\n const calculateParameters = (instance, dbCount) => {\n const { vCPU } = instance;\n \n // Calculate max_replication_slots\n // Ensure it's higher than the number of databases\n const max_replication_slots = Math.max(\n 10, // Minimum baseline\n dbCount + 2, // At least 2 more than number of databases\n vCPU * 2 // Consider instance size\n );\n\n // Calculate max_wal_sender\n // Must be at least equal to max_replication_slots\n const max_wal_sender = Math.max(\n max_replication_slots, // At least equal to replication slots\n 10, // Minimum baseline\n vCPU // Consider instance size\n );\n\n // Calculate max_logical_replication_workers\n // Must be at least max_replication_slots + reserve\n const reserve = 2; // As specified\n const max_logical_replication_workers = Math.max(\n max_replication_slots + reserve,\n 4, // Minimum baseline\n Math.floor(vCPU / 2) // Consider instance size\n );\n\n // Autovacuum workers typically 3 by default\n const autovacuum_max_workers = 3;\n\n // Parallel workers typically half of vCPU count\n const max_parallel_workers = Math.floor(vCPU / 2);\n\n // Calculate max_worker_processes\n // Sum of logical replication workers, autovacuum workers, and parallel workers\n const max_worker_processes = \n max_logical_replication_workers + \n autovacuum_max_workers + \n max_parallel_workers;\n\n // Construct parameters object with detailed descriptions\n const parameters = {\n max_replication_slots: {\n value: max_replication_slots,\n description: 'Maximum number of replication slots',\n calculation: `Max(10, ${dbCount} + 2, ${vCPU} * 2)`,\n recommendation: 'Should be 2+ more than number of databases'\n },\n max_wal_sender: {\n value: max_wal_sender,\n description: 'Maximum concurrent WAL sender processes',\n calculation: `Max(${max_replication_slots}, 10, ${vCPU})`,\n recommendation: 'Must be at least equal to max_replication_slots'\n },\n max_logical_replication_workers: {\n value: max_logical_replication_workers,\n description: 'Maximum logical replication workers',\n calculation: `Max(${max_replication_slots} + ${reserve}, 4, ${Math.floor(vCPU / 2)})`,\n recommendation: `Includes ${reserve} reserve workers`\n },\n max_worker_processes: {\n value: max_worker_processes,\n description: 'Total background worker processes',\n calculation: `${max_logical_replication_workers} + ${autovacuum_max_workers} + ${max_parallel_workers}`,\n recommendation: 'Combines replication, autovacuum, and parallel workers'\n }\n };\n\n return parameters;\n };\n\n const parameters = useMemo(() => \n calculateParameters(selectedInstance, numberOfDatabases), \n [selectedInstance, numberOfDatabases]\n );\n\n return (\n

🔧 RDS PostgreSQL Parameter Calculator

\n \n

\n Instance Type\n \n {selectedInstance.description}\n

\n \n

\n Number of Databases\n setNumberOfDatabases(Number(e.target.value))}\n style={{ width: '100%', padding: '5px' }}\n />\n

\n\n

Recommended Parameters

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

Parameter	Value	Description	Calculation
{name}	\n {param.value}\n	\n {param.description}\n	\n {param.calculation}\n

\n\n

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

\n\n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",4,["D",1736785587773],{"_103":220,"_155":139,"_153":115,"_95":99,"_162":221,"_160":161,"_100":222,"_154":-5,"_105":223,"_156":217,"_165":-5},"36f78e48-27b4-11f0-aecd-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction PostgreSQLParameterCalculator() {\n const instanceTypes = [\n { \n name: 'db.r5.large', \n vCPU: 2, \n description: 'Small instance, 2 vCPUs'\n },\n { \n name: 'db.r5.xlarge', \n vCPU: 4, \n description: 'Medium instance, 4 vCPUs'\n },\n { \n name: 'db.r5.2xlarge', \n vCPU: 8, \n description: 'Large instance, 8 vCPUs'\n },\n { \n name: 'db.r5.4xlarge', \n vCPU: 16, \n description: 'Very large instance, 16 vCPUs'\n }\n ];\n\n const [selectedInstance, setSelectedInstance] = useState(instanceTypes[0]);\n const [numberOfDatabases, setNumberOfDatabases] = useState(2);\n\n const calculateParameters = (instance, dbCount) => {\n const { vCPU } = instance;\n \n // Calculation logic for specific PostgreSQL parameters\n const parameters = {\n max_replication_slots: {\n value: Math.max(10, vCPU * 2, dbCount * 2),\n description: 'Maximum number of replication slots',\n recommendation: 'Depends on vCPUs and number of databases'\n },\n max_wal_sender: {\n value: Math.max(10, vCPU, dbCount),\n description: 'Maximum number of concurrent WAL sender processes',\n recommendation: 'Typically matches vCPU count or number of databases'\n },\n max_logical_replication_workers: {\n value: Math.max(4, Math.floor(vCPU / 2), dbCount),\n description: 'Maximum number of logical replication workers',\n recommendation: 'Proportional to vCPUs and databases'\n },\n max_worker_processes: {\n value: Math.max(8, vCPU * 2),\n description: 'Maximum number of background worker processes',\n recommendation: 'Should typically be 2x vCPU count'\n }\n };\n\n return parameters;\n };\n\n const parameters = useMemo(() => \n calculateParameters(selectedInstance, numberOfDatabases), \n [selectedInstance, numberOfDatabases]\n );\n\n return (\n

🔧 RDS PostgreSQL Parameter Calculator

\n \n

\n Instance Type\n \n {selectedInstance.description}\n

\n \n

\n Number of Databases\n setNumberOfDatabases(Number(e.target.value))}\n style={{ width: '100%', padding: '5px' }}\n />\n

\n\n

Recommended Parameters

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

Parameter	Value	Description
{name}	\n {param.value}\n	\n {param.description}\n

\n\n

Blue/Green Deployment Notes

Parameters are dynamically calculated based on instance vCPUs and database count
Always validate these recommendations in your specific environment
Adjust values based on your specific replication and workload requirements

\n\n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",3,["D",1736782758885],{"_103":225,"_155":139,"_153":115,"_95":99,"_162":226,"_160":161,"_100":227,"_154":-5,"_105":228,"_156":222,"_165":-5},"36f30620-27b4-11f0-aecd-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useMemo } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction PostgreSQLParameterCalculator() {\n const instanceTypes = [\n { \n name: 'db.r5.large', \n vCPU: 2, \n memory: 16, // GiB\n description: 'Small instance, suitable for low to moderate workloads'\n },\n { \n name: 'db.r5.xlarge', \n vCPU: 4, \n memory: 32, // GiB\n description: 'Medium instance, good for moderate database workloads'\n },\n { \n name: 'db.r5.2xlarge', \n vCPU: 8, \n memory: 64, // GiB\n description: 'Large instance, ideal for high-performance databases'\n },\n { \n name: 'db.r5.4xlarge', \n vCPU: 16, \n memory: 128, // GiB\n description: 'Very large instance for intensive database workloads'\n }\n ];\n\n const [selectedInstance, setSelectedInstance] = useState(instanceTypes[0]);\n const [workloadType, setWorkloadType] = useState('balanced');\n\n const calculateParameters = (instance, workloadType) => {\n const { vCPU, memory } = instance;\n \n // Calculation logic for key PostgreSQL parameters\n const parameters = {\n max_worker_processes: {\n value: Math.max(8, vCPU),\n description: 'Maximum number of background worker processes',\n recommendation: 'Should typically match or slightly exceed vCPU count'\n },\n max_parallel_workers: {\n value: Math.max(8, vCPU),\n description: 'Maximum number of parallel workers that can be active at one time',\n recommendation: 'Usually matches vCPU count'\n },\n shared_buffers: {\n value: Math.floor(memory * 0.25), // 25% of total memory\n unit: 'GB',\n description: 'Amount of memory used by PostgreSQL for caching data',\n recommendation: 'Typically 25% of total system memory'\n },\n effective_cache_size: {\n value: Math.floor(memory * 0.5), // 50% of total memory\n unit: 'GB',\n description: 'Estimated size of disk cache available to PostgreSQL',\n recommendation: 'Typically 50% of total system memory'\n },\n work_mem: {\n value: workloadType === 'high-complexity' \n ? Math.floor((memory * 1024) / (vCPU * 4)) \n : Math.floor((memory * 1024) / (vCPU * 8)),\n unit: 'kB',\n description: 'Maximum memory used for query operations like sorting',\n recommendation: 'Depends on workload complexity and number of concurrent connections'\n },\n maintenance_work_mem: {\n value: Math.floor(memory * 0.1), // 10% of total memory\n unit: 'MB',\n description: 'Maximum memory used for maintenance operations',\n recommendation: 'Typically 10% of total system memory'\n }\n };\n\n return parameters;\n };\n\n const parameters = useMemo(() => \n calculateParameters(selectedInstance, workloadType), \n [selectedInstance, workloadType]\n );\n\n return (\n

🔧 PostgreSQL Parameter Group Calculator for Blue/Green Deployments

\n \n

\n Select Instance Type\n \n {selectedInstance.description}\n

\n \n

\n Workload Type\n \n

\n\n

Recommended Parameters

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

Parameter	Value	Description
{name}	\n {param.value} {param.unit \|\| ''}\n	\n {param.description}\n

\n\n

Blue/Green Deployment Recommendations

Always test parameter changes in a staging environment first
Monitor database performance after parameter adjustments
These are general recommendations - your specific workload may vary

\n\n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",2,["D",1736782389091],{"_103":230,"_155":139,"_153":115,"_95":99,"_162":231,"_160":161,"_100":175,"_154":-5,"_105":232,"_156":227,"_165":-5},"36ee7d26-27b4-11f0-aecd-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction RDSBlueGreenDeploymentGuide() {\n const [parameters, setParameters] = useState({\n instanceClass: 'db.r5.large',\n storageType: 'aurora-iopt1',\n maxAllocatedStorage: 1000,\n backupRetentionPeriod: 7,\n performanceInsightsRetentionPeriod: 7,\n engineVersion: '15.4'\n });\n\n const parameterDescriptions = {\n instanceClass: {\n description: \"Compute and memory capacity of the database instance\",\n options: [\n { value: 'db.r5.large', label: 'db.r5.large (2 vCPU, 16 GiB)' },\n { value: 'db.r5.xlarge', label: 'db.r5.xlarge (4 vCPU, 32 GiB)' }, \n { value: 'db.r5.2xlarge', label: 'db.r5.2xlarge (8 vCPU, 64 GiB)' }\n ]\n },\n storageType: {\n description: \"Storage performance type for Aurora PostgreSQL\",\n options: [\n { value: 'aurora-iopt1', label: 'aurora-iopt1 (High performance I/O optimized storage)' },\n { value: 'aurora-standard', label: 'aurora-standard (Standard storage)' }\n ]\n },\n maxAllocatedStorage: {\n description: \"Maximum storage allocation for automatic scaling (in GB)\",\n min: 100,\n max: 64000\n },\n backupRetentionPeriod: {\n description: \"Number of days automated backups are retained\",\n min: 1,\n max: 35\n },\n performanceInsightsRetentionPeriod: {\n description: \"Number of months Performance Insights data is retained\",\n options: [\n { value: 7, label: '7 months' },\n { value: 731, label: '731 months (Maximum)' }\n ]\n },\n engineVersion: {\n description: \"PostgreSQL engine version for compatibility and features\",\n options: [\n { value: '15.4', label: '15.4' },\n { value: '14.7', label: '14.7' },\n { value: '13.10', label: '13.10' }\n ]\n }\n };\n\n const handleParameterChange = (param, value) => {\n setParameters(prev => ({...prev, [param]: value}));\n };\n\n return (\n

🔵🟢 RDS Aurora PostgreSQL Blue/Green Deployment Parameter Guide

Configure your Blue/Green deployment parameters with recommended settings.

\n \n {Object.entries(parameters).map(([param, value]) => (\n

\n \n {param.replace(/([A-Z])/g, ' $1').replace(/^./, str => str.toUpperCase())}\n
\n {parameterDescriptions[param].description}\n \n \n {parameterDescriptions[param].options ? (\n \n ) : (\n handleParameterChange(param, Number(e.target.value))}\n style={{ width: '100%', padding: '5px' }}\n />\n )}\n

\n ))}\n\n

Blue/Green Deployment Recommendations

Ensure minimal downtime during database upgrades
Use consistent instance types in blue and green environments
Test thoroughly before switching production traffic

\n\n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",["D",1736782288481],{"_103":234,"_155":139,"_153":115,"_95":99,"_162":235,"_160":161,"_100":32,"_154":-5,"_105":236,"_156":175,"_165":-5},"36e98e74-27b4-11f0-aecd-569c3dd06744","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction RDSBlueGreenDeploymentGuide() {\n const [parameters, setParameters] = useState({\n instanceClass: 'db.r5.large',\n storageType: 'aurora-iopt1',\n maxAllocatedStorage: 1000,\n backupRetentionPeriod: 7,\n performanceInsightsRetentionPeriod: 7,\n engineVersion: '15.4'\n });\n\n const parameterDescriptions = {\n instanceClass: {\n description: \"Compute and memory capacity of the database instance\",\n options: [\n \"db.r5.large (2 vCPU, 16 GiB)\",\n \"db.r5.xlarge (4 vCPU, 32 GiB)\", \n \"db.r5.2xlarge (8 vCPU, 64 GiB)\"\n ]\n },\n storageType: {\n description: \"Storage performance type for Aurora PostgreSQL\",\n options: [\n \"aurora-iopt1 (High performance I/O optimized storage)\",\n \"aurora-standard (Standard storage)\"\n ]\n },\n maxAllocatedStorage: {\n description: \"Maximum storage allocation for automatic scaling (in GB)\",\n min: 100,\n max: 64000\n },\n backupRetentionPeriod: {\n description: \"Number of days automated backups are retained\",\n min: 1,\n max: 35\n },\n performanceInsightsRetentionPeriod: {\n description: \"Number of months Performance Insights data is retained\",\n options: [7, 731]\n },\n engineVersion: {\n description: \"PostgreSQL engine version for compatibility and features\",\n options: ['15.4', '14.7', '13.10']\n }\n };\n\n const handleParameterChange = (param, value) => {\n setParameters(prev => ({...prev, [param]: value}));\n };\n\n return (\n

🔵🟢 RDS Aurora PostgreSQL Blue/Green Deployment Parameter Guide

Configure your Blue/Green deployment parameters with recommended settings.

\n \n {Object.entries(parameters).map(([param, value]) => (\n

\n ))}\n\n

Blue/Green Deployment Recommendations

Ensure minimal downtime during database upgrades
Use consistent instance types in blue and green environments
Test thoroughly before switching production traffic

\n\n \n

\n \n \n \n \n `, {\n headers: { \"content-type\": \"text/html\" }\n });\n}",["D",1736782261755],"versions",[239,241,242,243,244,245,246,247],{"_180":202,"_240":204},"previous",{"_180":204,"_240":209},{"_180":209,"_240":214},{"_180":214,"_240":219},{"_180":219,"_240":224},{"_180":224,"_240":229},{"_180":229,"_240":233},{"_180":233,"_240":-5},"versionNumber","page","hasNext","actionData","errors"]

History for main.tsx