Skip site navigation (1) Skip section navigation (2)

Re: no index-usage on aggregate-functions?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Harald Lau (Sector-X)" <harald(at)sector-x(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: no index-usage on aggregate-functions?
Date: 2004-06-29 13:44:06
Message-ID: 20040629134406.GC28041@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Jun 29, 2004 at 10:46:27 +0200,
  "Harald Lau (Sector-X)" <harald(at)sector-x(dot)de> wrote:
> 
> hmmmm...
> So, it seems that PG is not soooo well suited for a datawarehouse and/or performing extensive statistics/calculations/reportings on large tables, is it?

If you are doing lots of selects of aggregates relative to the number of
updates, you can cache the values of interest in derived tables and use
triggers to keep those tables up to date.

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-06-29 13:50:32
Subject: Re: postgres 7.4 at 100%
Previous:From: Bruno Wolff IIIDate: 2004-06-29 13:28:13
Subject: Re: postgres 7.4 at 100%

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group