X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2CD7E475E20 for ; Thu, 27 Feb 2003 14:29:36 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 10562-01 for ; Thu, 27 Feb 2003 14:29:25 -0500 (EST) Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150]) by postgresql.org (Postfix) with ESMTP id B91CC475A71 for ; Thu, 27 Feb 2003 13:48:13 -0500 (EST) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 73B533D28 for ; Thu, 27 Feb 2003 13:48:37 -0500 (EST) From: "Dan Langille" To: pgsql-sql@postgresql.org Date: Thu, 27 Feb 2003 13:51:40 -0500 MIME-Version: 1.0 Subject: Analyse article Message-ID: <3E5E17EC.10833.3D7E4559@localhost> X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/598 X-Sequence-Number: 11996 Hi folks, I've just finished writing up a bit on analyze. http://www.freebsddiary.org/postgresql-analyze.php It's not so much an explanation of the command as it is a series of examples which show a query evolving from a 4 second monster to a 14 ms speed daemon. Corrections, comments, etc appreciated. -- Dan Langille : http://www.langille.org/