X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0C563D1B1B4 for ; Tue, 29 Jun 2004 10:37:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63003-08 for ; Tue, 29 Jun 2004 13:37:32 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 9EB14D1B1AA for ; Tue, 29 Jun 2004 10:37:28 -0300 (ADT) Received: (qmail 28310 invoked by uid 500); 29 Jun 2004 13:44:06 -0000 Date: Tue, 29 Jun 2004 08:44:06 -0500 From: Bruno Wolff III To: "Harald Lau (Sector-X)" Cc: pgsql-performance@postgresql.org Subject: Re: no index-usage on aggregate-functions? Message-ID: <20040629134406.GC28041@wolff.to> Mail-Followup-To: "Harald Lau (Sector-X)" , pgsql-performance@postgresql.org References: <007d01c45da4$3726dcd0$6602a8c0@spock> <40E11BF0.3020109@familyhealth.com.au> <00b801c45db5$914330e0$6602a8c0@spock> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00b801c45db5$914330e0$6602a8c0@spock> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/292 X-Sequence-Number: 7350 On Tue, Jun 29, 2004 at 10:46:27 +0200, "Harald Lau (Sector-X)" 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.