Search Postgresql Archives

Re: Disabling/Enabling index before bulk loading

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Disabling/Enabling index before bulk loading
From: Ravi Krishna <srkrishna@xxxxxxxxx>
Date: Tue, 10 Jul 2018 15:25:53 -0400
Cc: PG mailing List <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CALd+dcfqWoDtX-D234p0Lh2H9eZb99qeeh3qFyg7vuVpsq8SAg@mail.gmail.com>
References: <67D408BB-5BF7-4607-A730-6F262F65811A@yahoo.com> <97b32f41-a133-d9d1-2dfa-0289038b25bf@aklaver.com> <E6BC317E-76F8-43C7-B735-429797952B28@yahoo.com> <CALd+dcfqWoDtX-D234p0Lh2H9eZb99qeeh3qFyg7vuVpsq8SAg@mail.gmail.com>

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Disabling/Enabling index before bulk loading
  - From: Nikolay Samokhvalov

References:
- Disabling/Enabling index before bulk loading
  - From: Ravi Krishna
- Re: Disabling/Enabling index before bulk loading
  - From: Adrian Klaver
- Re: Disabling/Enabling index before bulk loading
  - From: Ravi Krishna
- Re: Disabling/Enabling index before bulk loading
  - From: Vick Khera

Prev by Date: Re: Disabling/Enabling index before bulk loading
Next by Date: Re: Disabling/Enabling index before bulk loading
Previous by thread: Re: Disabling/Enabling index before bulk loading
Next by thread: Re: Disabling/Enabling index before bulk loading
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux