Re: Prefetch - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Prefetch
Date
Msg-id 42818FB1.4060403@familyhealth.com.au
Whole thread Raw
In response to Re: Prefetch  (Sam Vilain <sam@vilain.net>)
Responses Re: Prefetch  (Rod Taylor <pg@rbt.ca>)
Re: Prefetch  (Bricklen Anderson <BAnderson@PresiNET.com>)
Re: Prefetch  (Mischa Sandberg <mischa.sandberg@telus.net>)
List 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 by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Partitioning / Clustering
Next
From: Simon Riggs
Date:
Subject: Re: Partitioning / Clustering