If I correctly understand according to this advice: https://stackoverflow.com/questions/6146024/is-it-possible-to-temporarily-disable-an-index-in-postgres
it is possible to temporary disable indexes in all catalogue in order to increase performance of huge number of insert operations:
update pg_index
set indisready = false
<where ... >
But there is a problem: I run my instance on Amazon RDS and I have user granted access only to my particular schema. It is not granted to perform updates on pg_index
table. Other user is rdsadmin
which is internal Amazon's system user (according to this explanation: https://serverfault.com/questions/587695/what-is-the-rdsadmin-user-and-should-i-care ).
Are any other ways increase speed of huge number of inserts operation or disable indexes in this case?
INSERT
andUPDATE
will benefit when loading a lot of data. The docs say are quite exhaustive about this topic: postgresql.org/docs/current/static/populate.html