Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f950nRn22290 for ; Thu, 4 Oct 2001 20:49:27 -0400 (EDT) (envelope-from reedstrm@rice.edu) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id 32C5E68A63 for ; Thu, 4 Oct 2001 19:49:24 -0500 (CDT) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.22 #1 (Debian)) id 15pJB6-0008Sf-00 for ; Thu, 04 Oct 2001 19:49:24 -0500 Date: Thu, 4 Oct 2001 19:49:23 -0500 From: "Ross J. Reedstrom" To: pgsql-sql@postgresql.org Subject: Re: Indexing behavior Message-ID: <20011004194923.A32483@rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.18i X-Archive-Number: 200110/74 X-Sequence-Number: 5029 On Tue, Oct 02, 2001 at 09:47:09AM -0700, Josh Berkus wrote: > Folks, > > Q: Are brand-new rows included in PostgreSQL indexed immediately? > A: Yes, and that's why you don't add indices willy-nilly to all possible column combos on any given table: INSERTs get real slow. Ross