Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eo4Zn-0000Ec-1V for pgsql-admin@arkaria.postgresql.org; Tue, 20 Feb 2018 09:51:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eo4Zm-0002Yy-2B for pgsql-admin@arkaria.postgresql.org; Tue, 20 Feb 2018 09:51:06 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eo4Zl-0002Yk-O8 for pgsql-admin@lists.postgresql.org; Tue, 20 Feb 2018 09:51:05 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eo4Zj-0000BS-9g for pgsql-admin@postgresql.org; Tue, 20 Feb 2018 09:51:04 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id D1BFBB42C851 for ; Tue, 20 Feb 2018 02:51:01 -0700 (MST) Date: Tue, 20 Feb 2018 02:51:01 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1519120261856-0.post@n3.nabble.com> Subject: Script to find out 'Page Corruption' and 'Fragmentation' in PostgreSQL. MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, I am looking for a script and its explanation of how to calculate *page corruption* and* fragmentation* of a relation in PostgreSQL. Looked many blogs, but unable to find the one. Unable to understand the concept of database checksums part in Page Corruption and Fragmentation. Looking forward for your valuable suggestions. Help me to find these across the relations of Postgresql database. Thanks in Advance. regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html