Re: Performance vs Schemas

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