Re: Tuning queries on large database

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning queries on large database
Date: 2004-08-04 15:53:27
Message-ID: opsb7s3dwhcq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2004-08-04 15:56:41 FW: Tuning queries on large database
Previous Message Pierre-Frédéric Caillaud 2004-08-04 15:50:56 Re: Tuning queries on large database