Re: [Bizgres-general] Re: faster INSERT with possible

Поиск
Список
Период
Сортировка
От PFC
Тема Re: [Bizgres-general] Re: faster INSERT with possible
Дата
Msg-id op.suldqocith1vuj@localhost
обсуждение исходный текст
Ответ на Re: [Bizgres-general] Re: faster INSERT with possible  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
Дерево обсуждения 

> I had in mind the extra tables that an application sometimes needs to
> operate faster. Denormalisations, pre-joined tables, pre-calculated
> results, aggregated data. These are not temporary tables, just part of
> the application - multi-user tables that stay across shutdown/restart.

    You could also add caching search results for easy pagination without
redoing always entirely on each page the Big Slow Search Query that every
website has...

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [Bizgres-general] Re: faster INSERT with possible
Следующее
От: Matthew Schumacher
Дата:
Сообщение: Performance problems testing with Spamassassin 3.1.0 Bayes module.