[PERFORM] Performance vs Schemas

[Igor Maciel Macaubas]

Hi all,   I recently migrated my database from schema 'public' to multiple schema. I have around 100 tables, and divided them in 14 different schemas, and then adapted my application to use schemas as well. I could percept that the query / insert / update times get pretty much faster then when I was using the old unique schema, and I'd just like to confirm with you if using schemas speed up the things. Is that true ?   What else I can do to speed up the query processing, best pratices, recommendations ... ? What about indexed views, does postgresql supports it?   Regards, Igor -- [EMAIL PROTECTED]