Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id E61A4476412 for ; Thu, 20 Jun 2002 03:17:48 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id AC67D475EA0 for ; Thu, 20 Jun 2002 03:13:46 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g5K7GBY13069; Thu, 20 Jun 2002 10:16:11 +0300 Date: Thu, 20 Jun 2002 10:16:11 +0300 (EEST) From: Achilleus Mantzios To: Josh Berkus Cc: Jeff Self , Subject: Re: SQL performance issue with PostgreSQL compared to In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200206/266 X-Sequence-Number: 8231 On Wed, 19 Jun 2002, Josh Berkus wrote: > > The pgsql db is indexed on the > > 'authuser' field, and I've run 'analyze logfile'. > > He also needs to index the bytes field and the traffic field. And run ^^^^^^^ Index on an aggregate function??? I though we could only index plain normal column iscachable functions. Am i missing something? > > -Josh Berkus > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr