Re: Prefetch

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Prefetch
Дата
Msg-id 42818FB1.4060403@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Prefetch  (Sam Vilain <sam@vilain.net>)
Ответы Re: Prefetch  (Rod Taylor <pg@rbt.ca>)
Re: Prefetch  (Bricklen Anderson <BAnderson@PresiNET.com>)
Re: Prefetch  (Mischa Sandberg <mischa.sandberg@telus.net>)
Список pgsql-performance
> Another trick you can use with large data sets like this when you want
> results
> back in seconds is to have regularly updated tables that aggregate the data
> along each column normally aggregated against the main data set.

> Maybe some bright person will prove me wrong by posting some working
> information about how to get these apparently absent features working.

Most people just use simple triggers to maintain aggregate summary tables...

Chris

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Partitioning / Clustering
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Partitioning / Clustering