pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Harald Lau (Sector-X) <harald@sector-x.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: no index-usage on aggregate-functions?
Date: Tue, 29 Jun 2004 08:44:06 -0500
Message-ID: <20040629134406.GC28041@wolff.to> (raw)
In-Reply-To: <00b801c45db5$914330e0$6602a8c0@spock>
References: <007d01c45da4$3726dcd0$6602a8c0@spock>
	<40E11BF0.3020109@familyhealth.com.au>
	<00b801c45db5$914330e0$6602a8c0@spock>

On Tue, Jun 29, 2004 at 10:46:27 +0200,
  "Harald Lau (Sector-X)" <harald@sector-x.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.



view thread (8+ messages)  latest in thread

Message-ID: <20040629134406.GC28041@wolff.to>
Permalink:  ../20040629134406.GC28041@wolff.to/
Also on:    postgresql.org/message-id/20040629134406.GC28041@wolff.to

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: bruno@wolff.to, harald@sector-x.de
  Subject: Re: no index-usage on aggregate-functions?
  In-Reply-To: <20040629134406.GC28041@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox