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 1sbI4z-00FTcD-OR for pgsql-admin@arkaria.postgresql.org; Tue, 06 Aug 2024 11:10:13 +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 1sbI4y-00E6rd-3x for pgsql-admin@arkaria.postgresql.org; Tue, 06 Aug 2024 11:10:12 +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 1sbI4x-00E6nd-Ol for pgsql-admin@lists.postgresql.org; Tue, 06 Aug 2024 11:10:11 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sbI4r-003MkB-FJ for pgsql-admin@lists.postgresql.org; Tue, 06 Aug 2024 11:10:10 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-267b7ef154aso320977fac.0 for ; Tue, 06 Aug 2024 04:10:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1722942605; x=1723547405; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=0s/VOMpzse82mhtyZWVkFYTcw4c4aGrIYP1zhTyNpl0=; b=hnngtKu4EscOjnlnSRpEp/ryMZfsn0hBwfZnac10cs5sKdJqaFtVBZRY6oCGSdQQNF u9q9Pnn14qYn9wbUs+ut37Fg7E38bB6emJ917EOIIOzaihUuHsBUgTC8BmGNA3mTdppJ GyO/tGw6V3qCmJ175upPWOIJvRz19c7bB+H7DBqQEQu7kSDP+0SNbQ6otC3Z8axztZBu pjDRbd13BbsJ0KZCq8L3kXtJ9vYo7VhELpfhBL/23kbxCBXWJ3GFpIBGB7CUjuocAFv+ 6/q7CxuF/o8arOQwvw58S7Dz2vcCBRXKu9X/3PIYOTu3xNkPHeArrm9WrRNanyFIQtlI LaSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1722942605; x=1723547405; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=0s/VOMpzse82mhtyZWVkFYTcw4c4aGrIYP1zhTyNpl0=; b=VQ8N+9oxVMnoQpNzLs3dPuJ4By/Pfon89LIdZvNOCzK04n6svP7qRkumP0TZYp1J5r 4/UH20HkUI1StmOFx/lDUCdCIS8PG/f0YT1bvFudve4xP5l7MJGIflmP564EhRlgLTVU wYrxhFmtrYgAqlqYineiWn5jQsOfHp864hSCaIflTeAFMw2dNoiuNQP8tAaP82Eq8KDy MfaxausTB2xP27honlUpld5Hk49wa1Agd+U8rFKEKJTt50YdCVviCTQGpcuCahc0t+O3 aKDtQB8Ma/N+ZdhzBGjFtrpV2scM/7xA4mCKQgV+eVG/WgrkbHsvKEXhjQ403I5SqPK9 aOOA== X-Gm-Message-State: AOJu0Yx+WebyZb6L+AiNbZRi8OJU1vJ96bQngSm3gsdxIyekLn7JD2n6 eKzu7XHM6GxIK3Fxw9tGBtt8UyGGyEvmEXUfmVwDmCc2xsViUCIbo3Xo8GIITTF7eJtNRdZTlUQ XFr0BQlPBpepivltwRBqeJzOJes7KEA== X-Google-Smtp-Source: AGHT+IGm3LTM4WIM48KQovdK2wmqkccsQWqUQatABLcYmpKDeA1JFX5zyiZ29c+4kExokJniV53i50bQOtqAlLdPha4= X-Received: by 2002:a05:6871:e70c:b0:254:7211:424b with SMTP id 586e51a60fabf-26891a86bc8mr18031694fac.6.1722942604695; Tue, 06 Aug 2024 04:10:04 -0700 (PDT) MIME-Version: 1.0 From: Sathish Reddy Date: Tue, 6 Aug 2024 16:39:53 +0530 Message-ID: Subject: Pg_repack To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ebdf86061f01d593" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ebdf86061f01d593 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 --000000000000ebdf86061f01d593 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0
=C2=A0 We planning to create store pro= cedure (function) in postgres database to run pg_repack on removing bloatin= g 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 exa= mple for same.

=

Thanks=C2=A0
Sathishreddy=C2=A0
--000000000000ebdf86061f01d593--