What happens when a large table is alterted from UNLOGGED to LOGGED

From: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: What happens when a large table is alterted from UNLOGGED to LOGGED
Date: 2017-01-19 15:18:24
Message-ID: DM2PR05MB622E8AE2C3186BB6F8CA6618C7E0@DM2PR05MB622.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In order to speed up loading a set of 12 tables, I have declared them as UNLOGGED. As per documentation, an unlogged table will also have unlogged indices.

Question: When the table is converted back to logged, does PG rebuild all indices before marking them as logged. Also what about FKY constraints. Does it revalidate them ?

thanks.

Browse pgsql-general by date

  From Date Subject
Next Message PAWAN SHARMA 2017-01-19 20:46:35 factor effecting performance of postgres
Previous Message Adrian Klaver 2017-01-19 14:51:00 Re: Moving from 9.5 to 9.6