Re: Strangely Variable Query Performance

Поиск
Список
Период
Сортировка
От Steve
Тема Re: Strangely Variable Query Performance
Дата
Msg-id Pine.GSO.4.64.0704121822090.17955@kittyhawk.tanabi.org
обсуждение исходный текст
Ответ на Re: Strangely Variable Query Performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
> [ itch... ]  That code is just completely wrong, because the contents
> of a TEXT datum aren't guaranteed null-terminated.  It'd be better to
> invoke bttextcmp and negate its result.
>
> That's not relevant to your immediate problem, but if you've noticed
> any strange behavior with your text_revop indexes, that's the reason...

     The indexes have all worked, though I'll make the change anyway.
Documentation on how to code these things is pretty sketchy and I believe
I followed an example on the site if I remember right. :/

Thanks for the info though :)


Steve

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strangely Variable Query Performance
Следующее
От: Steve
Дата:
Сообщение: Re: Strangely Variable Query Performance