Re: [PERFORM] Performance of information_schema with many schemata and tables

2017-06-28 Thread Ulf Lohbrügge
2017-06-28 10:43 GMT+02:00 Pritam Baral : > > > On Wednesday 28 June 2017 02:00 PM, Ulf Lohbrügge wrote: > > Nope, I didn't try that yet. But I don't have the impression that > reindexing the indexes in information_schema will help. The table > information_schema.tables consists of the following i

Re: [PERFORM] Performance of information_schema with many schemata and tables

2017-06-28 Thread Ulf Lohbrügge
Nope, I didn't try that yet. But I don't have the impression that reindexing the indexes in information_schema will help. The table information_schema.tables consists of the following indexes: "pg_class_oid_index" UNIQUE, btree (oid) "pg_class_relname_nsp_index" UNIQUE, btree (relname, rel

Re: [PERFORM] Performance of information_schema with many schemata and tables

2017-06-27 Thread Pritam Baral
On Wednesday 28 June 2017 05:27 AM, Ulf Lohbrügge wrote: > Hi all, > > we use schemata to separate our customers in a multi-tenant setup (9.5.7, > Debian stable). Each tenant is managed in his own schema with all the tables > that only he can access. All tables in all schemata are the same in ter