Re: Performance vs Schemas

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Performance vs Schemas
Дата
Msg-id 1097801555.29932.11.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Performance vs Schemas  ("Igor Maciel Macaubas" <igor@providerst.com.br>)
Список 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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Aaron Werman
Дата:
Сообщение: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
Следующее
От: Kevin Brown
Дата:
Сообщение: Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...