Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3aFO-00DOt6-CI for pgsql-admin@arkaria.postgresql.org; Wed, 23 Oct 2024 12:13:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t3aFL-00927b-V4 for pgsql-admin@arkaria.postgresql.org; Wed, 23 Oct 2024 12:13:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3aFL-009250-Cy for pgsql-admin@lists.postgresql.org; Wed, 23 Oct 2024 12:13:51 +0000 Received: from mail-yw1-x1134.google.com ([2607:f8b0:4864:20::1134]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t3aFJ-002YxQ-05 for pgsql-admin@lists.postgresql.org; Wed, 23 Oct 2024 12:13:51 +0000 Received: by mail-yw1-x1134.google.com with SMTP id 00721157ae682-6e5ef7527deso41123417b3.0 for ; Wed, 23 Oct 2024 05:13:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=evaristesys-com.20230601.gappssmtp.com; s=20230601; t=1729685626; x=1730290426; darn=lists.postgresql.org; h=message-id:in-reply-to:to:references:date:subject:mime-version :content-transfer-encoding:from:from:to:cc:subject:date:message-id :reply-to; bh=CH1bNcjGKHCa48nofqs0YIAsDQZ7TYGle1KoU0Imvqw=; b=U0QNc3sawH9uZO4ovGIaFqlqLprES4daxPPUud1s4zKQ5vIa3FQ8C3qThJqfdgi6LF xS2gfXUKSxWulGP2i2e+RaFNBuL1AaZdUip9l4hxVS/VH4KdC4RknyH+wETY30FoIPlJ qSL8E4RMf4J4Pxdz2eC0x92YsaULQ/ir9AheWGESyI0IqFDsZY2mAlhFV+6hqNQZx6fR qIvT1Dmxo2em2lBzpNqgmCPsKn7f2fS6Roc3wqqzIhf/rlds4t49TNykZBZsAXr+lpZT k7ZePwCAT52Ap/CDxTaMfaGvqdx0PlcEcwpkCcrQpamGjf4sC5+OQ6RuRo2A0/mccZeW wL0g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729685626; x=1730290426; h=message-id:in-reply-to:to:references:date:subject:mime-version :content-transfer-encoding:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=CH1bNcjGKHCa48nofqs0YIAsDQZ7TYGle1KoU0Imvqw=; b=gCpijbQ2m2eahkr+ibBqzE+g51WZocsG07D/LoOvgWPIS63SPUK/OKEB+vLXt9Cund Lodo+srWxSxq7aMB4a20AB4eEtLGhaG59fdNV7SF4NLbTXK1M+YZtM2Q/IoRUAk380RI c/BoVj3lS4QrKmYd7ru44epRvn4kxJwrPvofGCnFq8yXOAH5W7pKm7RzRkFZXuhtiq1U 7UyGCWLMUHQ3ZOabfGqpUYSNLbHk3yscXeoezrldyF0v5XqqooN5pJN4kfLJa1y68DL+ T8gZlswNkb1EFELEYvISJrQxT3hTf0QLmaQEa9tryAIc0t2jpiBDZEDC8mnraBFmCyzq pSuQ== X-Gm-Message-State: AOJu0Yyu3VvO8FH1/CdK4nqjDVfSi34iL9d8ohwdu59v/SvYu6LvmpsN 1r7/+0c31fP4cUrW9nB75OgF0Xb6EBLsqLO4ZCR9ULefe8M/ZR/sVSml+95zaCFEEn5zbTlgsLF p X-Google-Smtp-Source: AGHT+IGPHbbrLYiLGH9AeNvQf/g3+6rZsyDXuYEc/LSatAs8XwPnSgSlaEihPBeQmXSWkI+0s8pbFA== X-Received: by 2002:a05:690c:f15:b0:6e7:f940:fe81 with SMTP id 00721157ae682-6e7f940ffc9mr11393447b3.6.1729685626623; Wed, 23 Oct 2024 05:13:46 -0700 (PDT) Received: from smtpclient.apple ([2600:1700:e191:9050:31d4:2580:1c6b:1a01]) by smtp.gmail.com with ESMTPSA id 00721157ae682-6e5f5d6f92bsm15229997b3.138.2024.10.23.05.13.46 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 23 Oct 2024 05:13:46 -0700 (PDT) From: Alex Balashov Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3818.100.11.1.3\)) Subject: Re: Postgres capacity planning. Date: Wed, 23 Oct 2024 08:13:35 -0400 References: To: pgsql-admin@lists.postgresql.org In-Reply-To: Message-Id: X-Mailer: Apple Mail (2.3818.100.11.1.3) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 23, 2024, at 8:02=E2=80=AFam, Daulat = wrote: >=20 > Could anyone please suggest any freeware tools, scripts, or ideas for = creating a capacity planning solution for a PostgreSQL database? Thank = you. I suppose this is one of those areas where "knowing Postgres well" is = the idea, and it's unlikely that this can be replaced with a tool. --=20 Alex Balashov Principal Consultant Evariste Systems LLC Web: https://evaristesys.com Tel: +1-706-510-6800