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 по дате отправления: