Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ff2LQ-00054E-Ia for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jul 2018 12:11:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ff2LM-0001vs-Kl for pgsql-admin@arkaria.postgresql.org; Mon, 16 Jul 2018 12:11:08 +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.89) (envelope-from ) id 1ff2LM-0001vk-7t for pgsql-admin@lists.postgresql.org; Mon, 16 Jul 2018 12:11:08 +0000 Received: from mail-pf0-x242.google.com ([2607:f8b0:400e:c00::242]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ff2LG-0006Qi-GD for pgsql-admin@postgresql.org; Mon, 16 Jul 2018 12:11:07 +0000 Received: by mail-pf0-x242.google.com with SMTP id l123-v6so26163376pfl.13 for ; Mon, 16 Jul 2018 05:11:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:date:subject:message-id :to; bh=YY3JuX7cbTeKcDFaDjgM7qFAjE4hNNozEBZvKmY1nDg=; b=tNt8xdlfYSaDU3W1IwdedD++bVmiWvH6hjkqudcItF6rAETkGkC0dC0q863tx0jHHs s/4la8ji+qIArJvAk/zvbjL8/YpLN7bytRr+XKsdIPDpBj/C7RGWoFy4tbEL+OXNB4bk xdKtmR4nL6mUY0Jj3QBGttPNGm4dUQl6s0na/2Y1BzmnKQdeAbodZkAfTiwB78RXCQ2D qqtZYwjSxl9g7/2+xObbU9Z+BfQEwXnl++mw3/Jzei/YXxZAeaggRYR1Wnm5q2m0tEaq ybhtrqrnk/CLKCe3hdpZ8I3zGPQE7lwQFsPYTB+6pygHl1BLzPAYFmNe+NxIGTVD1CsV CzSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version:date :subject:message-id:to; bh=YY3JuX7cbTeKcDFaDjgM7qFAjE4hNNozEBZvKmY1nDg=; b=CmrgR4bZHVGjebU38cA+Xmw5bRurnjbjF1y7ggvdh/AJThKFdUoYtZy66Ek07bcVcg 8F1BxloL4fFs99VZhnGHibmtD94ee+SvHB+T00Z1b2yTuDnFG6OH8fBsOO5EO4DGKCJ6 pg8qr6OxNMXsfXuXhuA+RiHh2tSqvimR68/Lp2JMwhT//b2BjhcuA3mGlB9p9KJNqzUw U6NQULoAWEVeC/BNuF58YuTbPRicNH1mGDeWKAI7RgLGa5U7dqGWmqsAfyLbtMbn+kk+ EFVCzp9Kk39C1O+5fftnIdP7HzlS8ZW3Wfwxh5eWB7Ctl+t/AD5oAjruzGq8Sxfk4VpW IJkA== X-Gm-Message-State: AOUpUlHugiMREwOFzQN2R40SwuGgcDeCgU46oM/6agpOtihCWPmM76kz hWRr1vrJ0DMtM1HKDdIYkL8qVPuP X-Google-Smtp-Source: AAOMgpejdPIagI/GM8MEAD/WQLMWLF1ByUx1usiP3uTCUUXrJoYvIVoVa0RoB5DUlqDWK/diKGpLmA== X-Received: by 2002:a62:170c:: with SMTP id 12-v6mr17732482pfx.139.1531743060817; Mon, 16 Jul 2018 05:11:00 -0700 (PDT) Received: from [100.120.239.207] ([42.109.140.252]) by smtp.gmail.com with ESMTPSA id n83-v6sm69831503pfk.19.2018.07.16.05.10.58 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 16 Jul 2018 05:10:59 -0700 (PDT) From: Rahul Saha Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) Date: Mon, 16 Jul 2018 17:40:55 +0530 Subject: [Admin] Deleting Orphan Relfilenode Message-Id: <33986830-A802-43DD-AABB-6035B37251EC@gmail.com> To: "pgsql-admin@postgresql.org pgsql-admin@postgresql.org" X-Mailer: iPhone Mail (15F79) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Experts, Background - PG version 9.4 Running in Linux Rhel We have a scenario where we ran Vacuum Full (2 TB Table)but due to some reas= on Vacuum Full failed.=20 These have let almost 1 TB orphan Relfilenodes inside base directory under t= he concern database which does not map with pg_class.=20 For example - Select * from pg_class where relfilenode =3D 123456. It does n= ot return any row but those relfilenode exist inside base.=20 It would be great if you can suggest how to remove those orphan files. I kno= w definitely manually deleting is not suggested so thought to know your sugg= estions.=20 Kind Regards, Rahul Saha