Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Indexing behavior
- From: "Ross J. Reedstrom" <reedstrm(at)rice(dot)edu>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Indexing behavior
- Date: Thu, 4 Oct 2001 19:49:23 -0500
- Message-id: <20011004194923.A32483@rice.edu> <text/plain>
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
- References:
- Indexing behavior
- From: Josh Berkus
- Indexing behavior
- Prev by Date: Re: ORDER BY case insensitive?
- Next by Date: Re: Alias Join Table
- Previous by thread: Indexing behavior
- Next by thread: jdbc driver
- Indexes: