Postgres Pro
Downloads
Home   >   mailing lists

Re: Tuning queries on large database - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: Tuning queries on large database
Date
Msg-id opsb7s3dwhcq72hf@musicbox
Whole thread Raw
In response to Re: Tuning queries on large database  (Valerie Schneider DSI/DEV <Valerie.Schneider@meteo.fr>)
List pgsql-performance
Tree view 
    You often make sums. Why not use separate tables to cache these sums by
month, by poste, by whatever ?

    Rule on insert on the big table updates the cache tables.

pgsql-performance by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Tuning queries on large database
Next
From: "Merlin Moncure"
Date:
Subject: FW: Tuning queries on large database