Re: Query performance

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Query performance
Дата
Msg-id CAFj8pRD==gcFXqYE+vX-e+CAqrN9Zs88rda5z28xG1PNEzqxNA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query performance  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-performance


2015-01-31 2:40 GMT+01:00 Jim Nasby <Jim.Nasby@bluetreble.com>:
On 1/25/15 2:03 AM, Pavel Stehule wrote:
    It might not always be an integer, just happens to be so here.
    Should I try text instead? I don't have to have the case-insensitive
    matching.


text can be better

bytea would be even better yet, because that will always be a straight binary comparison. text will worry about conversion and what not (though, perhaps there's a way to force that to use C or SQL instead of something like UTF8, short of changing the encoding of the whole database).

true,

good idea

Regards

Pavel
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Performance of Postgresql Foreign Data Wrapper
Следующее
От: Christian Weyer
Дата:
Сообщение: Unexpected (bad) performance when querying indexed JSONB column