Performance vs Schemas - Mailing list pgsql-performance

From Igor Maciel Macaubas
Subject Performance vs Schemas
Date
Msg-id 003101c4b21d$10f00e60$6801a8c0@providerst.local
Whole thread Raw
Responses Re: Performance vs Schemas  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
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,
 

pgsql-performance by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: Performance vs Schemas