| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Igor Maciel Macaubas <igor(at)providerst(dot)com(dot)br> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance vs Schemas |
| Date: | 2004-10-15 00:52:35 |
| Message-ID: | 1097801555.29932.11.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, 2004-10-15 at 04:38, Igor Maciel Macaubas wrote:
> 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
> ?
Schemas are a namespacing technique; AFAIK they shouldn't significantly
affect performance (either positively or negatively).
> What about indexed views, does postgresql supports it?
No, you'll need to create indexes on the view's base tables.
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Brown | 2004-10-15 01:08:41 | Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... |
| Previous Message | Aaron Werman | 2004-10-15 00:25:36 | mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... |