X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id C9ABFD1C50B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 15:19:16 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 43720-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 12:17:54 -0300 (ADT)
Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 5F7D2D1C48E
	for <pgsql-sql@postgresql.org>; Wed,  6 Aug 2003 12:19:04 -0300 (ADT)
Received: from mailgw1.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253])
	by ucsns.ucs.co.za (Postfix) with ESMTP id 1DBD32BD8A
	for <pgsql-sql@postgresql.org>; Wed,  6 Aug 2003 17:18:58 +0200 (SAST)
Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3])
	by mailgw1.ucs.co.za (Postfix) with ESMTP id 5739CD9FAA
	for <pgsql-sql@postgresql.org>; Wed,  6 Aug 2003 17:18:57 +0200 (SAST)
Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148])
	by jhb.ucs.co.za (Postfix) with SMTP id 8E66F9737E
	for <pgsql-sql@postgresql.org>; Wed,  6 Aug 2003 17:18:56 +0200 (SAST)
Date: Wed, 6 Aug 2003 17:18:55 +0200
From: Stef <svb@ucs.co.za>
To: Postgres SQL List <pgsql-sql@postgresql.org>
Subject: Analyze makes queries slow...
Message-Id: <20030806171855.6c9ebf4d.svb@ucs.co.za>
X-Mailer: Sylpheed version 0.9.3claws (GTK+ 1.2.10; i386-pc-linux-gnu)
User-Agent: sillypheed-claws (anti-aliased)
X-Face: $Gp2`m@jO/6Mi&B3cB6PFD,YHXma7tm3=s0QH_tqN[HIic~LmmuG><;
	&CJqmR|_qJ(.I.#-eT:/V"~6@=#Bd!Z5!B++-@$*VRd%bX.`f1;
	js/n]=FQo,rXk)X:HPX|'7HkY([-o9tD/moi>q/Q7D#n%ypoi{c/tvb0^'wpj_pza|7[}<WRkRkKlt%J`9*R3dU`6A_gsnIW"8W|5a"g}+=<}}IxdGzU;
	uB
X-Operating-System: sid
X-X-X: _-^-_
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/53
X-Sequence-Number: 14669

Hi all,

I have a problem :

A select statement that selects from 7 tables,
groups the information by 6 columns of the
tables involved.

When there are no rows in pg_statistics,
the query runs under 3 minutes.

When I analyze the biggest table of the 7
(approx 1000000 rows), the query takes longer than
12 Hours (Had to kill it eventually).

I have the explain plan of the original, under 3 minutes
query, and would like to reverse engineer this, to
build up a query with proper join statements, as I understand
that this is a way of forcing the planner to join the table
in a faster way.

I got very close a couple of times, but still can't get it 100%
the same as what the planner did prior to analyzing.

The database is actually faster when analyzed, except
for two or three multiple join queries (which don't finish
after analyze) So I would like to make an exception
for the tables that are used in these queries only,
or do proper joins.

Can anybody help, or give some links to good 
help resources?

TIA
Stefan