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

[PERFORM] Performance of information_schema with many schemata and tables

2017-06-27 Thread Ulf Lohbrügge
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 terms of their DDL: Every tenant uses e.g. his own table 'address'. We