Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Limitation

From: Dustin Sallings <dustin(at)spy(dot)net>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: John Huttley <john(at)mwk(dot)co(dot)nz>, pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Limitation
Date: 1999-06-24 19:05:59
Message-ID: Pine.SGI.3.95.990624120446.28677A-100000@bleu.west.spy.net (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, 24 Jun 1999, Bruce Momjian wrote:

# > 1.  Have more than 7 fields on a btree index
# 
# We have never understood why someone would want an index with more than
# seven columns. 

	Honestly, I think it's the same reason someone would want to
insert data as a single string, then create a view that does substrings to
produce the appearance of a multi-column table (which, I assume is then    
selected on from certain fields, causing table scans).  Sometimes, people
try to wedge efficiency into an inefficient design, which rarely works.
My approach here would be to substr before insertion, then make a view to
concatenate the results.

--
SA, beyond.com           My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE 
L_______________________ I hope the answer won't upset her. ____________


In response to

pgsql-general by date

Next:From: Hub.Org News AdminDate: 1999-06-24 21:33:42
Subject:
Previous:From: Roeland M.J. MeyerDate: 1999-06-24 16:18:42
Subject: RE: [GENERAL] Limitation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group