Re: Indexing behavior

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Indexing behavior
Date: 2001-10-05 00:49:23
Message-ID: 20011004194923.A32483@rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-10-05 01:01:54 Re: Alias Join Table
Previous Message Tom Lane 2001-10-05 00:32:08 Re: ORDER BY case insensitive?