On Tue, Jun 29, 2004 at 10:46:27 +0200, "Harald Lau (Sector-X)" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster