Performance vs Schemas

From: "Igor Maciel Macaubas" <igor(at)providerst(dot)com(dot)br>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Performance vs Schemas
Date: 2004-10-14 18:38:52
Message-ID: 003101c4b21d$10f00e60$6801a8c0@providerst.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,
Igor
--
igor(at)providerst(dot)com(dot)br

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory S. Williamson 2004-10-14 18:45:10 Re: Performance vs Schemas
Previous Message Magnus Hagander 2004-10-14 17:29:25 Re: Performance on Win32 vs Cygwin