Renaming 800GB size table in postgresql

From: satish v <vuyyuru(dot)satish59(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Renaming 800GB size table in postgresql
Date: 2021-10-19 16:48:21
Message-ID: CAPG-CvWHHKeYY9cWXg16j602EfGVUr8z37aJ0Z8DNfQa4HLzeA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

we have the table around 800GB size and 1,23,000 records. we want to
rename the table.it is having primary key only, no foreign key
constraints and indexes.how much time it will take to rename the table.

Thanks in Advance.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2021-10-19 17:17:23 Re: Renaming 800GB size table in postgresql
Previous Message Zahid Rahman 2021-10-19 11:59:08 Re: database on selected disk