Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BB138476048 for ; Thu, 2 Jan 2003 16:11:33 -0500 (EST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 401AB475F5D for ; Thu, 2 Jan 2003 16:11:33 -0500 (EST) Received: from samurai.com (localhost [127.0.0.1]) by bob.samurai.com (Postfix) with SMTP id 75E3B1F2C; Thu, 2 Jan 2003 16:11:34 -0500 (EST) Received: from cpe00d0096a6cd5.cpe.net.cable.rogers.com ([24.112.166.30]) (SquirrelMail authenticated user neilc) by mailbox.samurai.com with HTTP; Thu, 2 Jan 2003 16:11:34 -0500 (EST) Message-ID: <1455.24.112.166.30.1041541894.squirrel@mailbox.samurai.com> Date: Thu, 2 Jan 2003 16:11:34 -0500 (EST) Subject: Re: join over 12 tables takes 3 secs to plan From: "Neil Conway" To: In-Reply-To: <54E69E80-1E96-11D7-9244-000393B4BFF6@gmx.net> References: <1309.24.112.166.30.1041540084.squirrel@mailbox.samurai.com> <54E69E80-1E96-11D7-9244-000393B4BFF6@gmx.net> X-Priority: 3 Importance: Normal Cc: X-Mailer: SquirrelMail (version 1.2.9) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/12 X-Sequence-Number: 659 Hilmar Lapp said: > Thanks for the tip. I have to admit that I have zero experience with > tuning GAs. If anyone could provide a starter which parameters are best > to start with? Or is it in the docs? http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/runtime-config.html lists the available options. I'd think that GEQO_EFFORT, GEQO_GENERATIONS, and GEQO_POOL_SIZE would be the parameters that would effect performance the most. Cheers, Neil