X-Original-To: pgsql-sql@postgresql.org Received: from email04.aon.at (WARSL401PIP5.highway.telekom.at [195.3.96.90]) by postgresql.org (Postfix) with SMTP id 27B3E475FD9 for ; Mon, 17 Mar 2003 03:09:39 -0500 (EST) Received: (qmail 197228 invoked from network); 17 Mar 2003 08:09:39 -0000 Received: from m170p001.dipool.highway.telekom.at (HELO cantor) ([62.46.11.33]) (envelope-sender ) by qmail4rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 17 Mar 2003 08:09:38 -0000 From: Manfred Koizar To: Joost Witteveen Cc: pgsql-sql@postgresql.org Subject: Re: create index right after create table not working? Date: Mon, 17 Mar 2003 09:08:42 +0100 Message-ID: References: <20030315235332.GA32358@co.uea.org> In-Reply-To: <20030315235332.GA32358@co.uea.org> X-Mailer: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/379 X-Sequence-Number: 12418 On Sun, 16 Mar 2003 00:53:32 +0100, Joost Witteveen wrote: >Can CREATE index commands be issued right after the CREATE TABLE? Yes. And the index will be used if you do ANALYSE yourtable; or even better VACUUM ANALYSE yourtable; after you have initially loaded your table and before you start querying it. Servus Manfred