Home > mailing lists

Re: Disabling/Enabling index before bulk loading - Mailing list pgsql-general

From	Ravi Krishna
Subject	Re: Disabling/Enabling index before bulk loading
Date	July 11, 2018 01:25:53
Msg-id	ACDA191F-CF08-4CAA-9569-41F5CB437A55@yahoo.com Whole thread Raw
In response to	Re: Disabling/Enabling index before bulk loading (Vick Khera <vivek@khera.org>)
Responses	Re: Disabling/Enabling index before bulk loading (Nikolay Samokhvalov <samokhvalov@gmail.com>)
List	pgsql-general

https://fle.github.io/temporarily-disable-all-indexes-of-a-postgresql-table.html

This does not work in RDS. In order to update system catalog tables (pg_index), one needs privileges which is

denied in RDS. In RDS terminology, the user must belong to role rdsadmin and that role is reserved only for AWS

internal users.

From: Vick Khera
Date: 11 July 2018, 00:38:11
Subject: Re: Disabling/Enabling index before bulk loading

From: Nikolay Samokhvalov
Date: 11 July 2018, 02:18:39
Subject: Re: Disabling/Enabling index before bulk loading