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 1sbI3D-00FTSd-Hn for pgsql-admin@arkaria.postgresql.org; Tue, 06 Aug 2024 11:08:23 +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 1sbI3A-00E2Oe-T2 for pgsql-admin@arkaria.postgresql.org; Tue, 06 Aug 2024 11:08:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sbI3A-00E2OW-H6 for pgsql-admin@lists.postgresql.org; Tue, 06 Aug 2024 11:08:20 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sbI36-003Mis-Si for pgsql-admin@lists.postgresql.org; Tue, 06 Aug 2024 11:08:19 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-260f863108fso305029fac.1 for ; Tue, 06 Aug 2024 04:08:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1722942496; x=1723547296; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=/oKatCWJyezf6/QI1K9/BuNu0wzY2sM4nI32tBVlH+g=; b=CeUqub2RjvWtHdRXBoek7k9wKq7powriTx0uBcuvVW/qPvAvXWbJDLtahfB/YBUcNn 53YLNJD6ycl41QSf3gTq+PSiYoRtlum0U+1b9X47XyZME/A72ka2GAROUK2G/pzVhgtp TYuiaNaAh9ZrRcEt9Zoq4oiRyD1rm8EkXMEYYQ5W0fjc66jaLsk66bcyW8dYtwJitelh fJ4O6x1yKkEqSJaPXngYmZz8oAw2mTNUQdL3Gy0g5jNjRi23yLFb4fxIwa6DWRuAAir0 oAD0yhn563Xxp9E+Wym4GBHZUPGTm0UAgxjJ1TLNA5jBXnliuvv1btUmoFHmDTQ3rWnU g9XA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1722942496; x=1723547296; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=/oKatCWJyezf6/QI1K9/BuNu0wzY2sM4nI32tBVlH+g=; b=SzfHGrKRNsf024vJUn9CqBbOjZbkLtQWx5X7VE9FLf3yKSWGIeoNvQCUzmGVrVyLXl FXjpGdNJSeQubldFsCsrkhvhGl530ewKKWMpMJi/4hOdlSEJoQEval/c/Eqqf+w/eSGE B7cevhtgQ3r/OKFVhiRORPxqdTnlaMLch3RlFRGY5VJFqVi4W0yt6QfJKCXkKLufiCQt qEuaXo5QQ84/gDIPG7UBlfvRCKFllQrDYO7pyfuTm6ZMPPF/5mhgGMAZ5dYbthU5u4OT iGgy4QCVxw8O2gUC8q7QRtfykpeftmmMfvdpQ/AP1vc4GYBQGTLQGYgp7RSqWR8ua0c6 0BMw== X-Gm-Message-State: AOJu0YzmoirSutZo23426XtnWJyUQKWKTae71rg/lR+YIPfRhKNqE9ff SBzFzRGRFw5wUFDNWqgMJCvZwWnt9zhWsN2f/JuNG33uyB0UwJSTaAOOsI6nQfd1eFYgi93sFCu r0qSNFZMslXsOQRghQJvYnz7li93shg== X-Google-Smtp-Source: AGHT+IEefmtW/4GyRhEY1Q8+/eXWxyjYUoPPOs2s0qApaX69W6q7v2yth56Oj1LO+/b3gb+e4kqccfXfVUj7s6Y9Fc4= X-Received: by 2002:a05:6870:391e:b0:25b:3e23:e5ef with SMTP id 586e51a60fabf-26891a82e87mr17517983fac.3.1722942495692; Tue, 06 Aug 2024 04:08:15 -0700 (PDT) MIME-Version: 1.0 From: Sathish Reddy Date: Tue, 6 Aug 2024 16:38:03 +0530 Message-ID: Subject: Pg_repack To: pgsql-admin@lists.postgresql.org, keith.fiske@crunchydata.com, Keith , khan Affan Content-Type: multipart/alternative; boundary="0000000000006c9e32061f01cf85" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006c9e32061f01cf85 Content-Type: text/plain; charset="UTF-8" Hi We planning to create store procedure (function) in postgres database to run pg_repack on removing bloating of table or index by using within postgres instance. Please help me on details on steps with example for same. Thanks Sathishreddy --0000000000006c9e32061f01cf85 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0
=C2=A0 We planning to create st= ore procedure (function) in postgres database to run pg_repack on removing = bloating of table or index by using within postgres instance.
=C2=A0=C2=A0
=C2=A0 =C2=A0 Please help me = on details on steps with example for same.


Thanks=C2=A0
Sathishreddy=C2=A0
--0000000000006c9e32061f01cf85--