Re: Prefetch

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Sam Vilain <sam(at)vilain(dot)net>
Cc: molson(at)oceanconsulting(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Prefetch
Date: 2005-05-11 04:53:05
Message-ID: 42818FB1.4060403@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kim Bisgaard 2005-05-11 07:05:05 Re: full outer performance problem
Previous Message Josh Berkus 2005-05-11 04:44:06 Re: Partitioning / Clustering