Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing behavior - Mailing list pgsql-sql

From Ross J. Reedstrom
Subject Re: Indexing behavior
Date
Msg-id 20011004194923.A32483@rice.edu
Whole thread Raw
In response to Indexing behavior  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: ORDER BY case insensitive?
Next
From: "Josh Berkus"
Date:
Subject: Re: Alias Join Table