Re: What is wrong with hashed index usage?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: What is wrong with hashed index usage?
Дата
Msg-id 200206212012.g5LKCNB14956@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: What is wrong with hashed index usage?  (Larry Rosenman <ler@lerctr.org>)
Список pgsql-hackers
Larry Rosenman wrote:
> On Fri, 2002-06-21 at 11:51, Bruce Momjian wrote:
> > Tom Lane wrote:
> > > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
> > 
> > > 
> > > > How about an elog(NOTICE) for hash use?
> > > 
> > > I don't think that's appropriate.
> > 
> > I was thinking of this during CREATE INDEX ... hash:
> > 
> >     NOTICE:  Hash index use is discouraged.  See the CREATE INDEX
> >     reference page for more information.
> > 
> > Does anyone else like/dislike that?
> I dislike it.  Some clients/dba's will wonder why we even have them. 
> 
> Why should we bug the DBA on EVERY index that is a hash? 
> 
> I know I personally hate the FreeBSD linker warnings about certain
> functions, and don't like that precedent. 

OK, that's enough of a negative vote for me.  So you feel the
documentation change is enough?  Tom thinks so too.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: What is wrong with hashed index usage?
Следующее
От: "Dann Corbit"
Дата:
Сообщение: Re: What is wrong with hashed index usage?