Re: Query performance - Mailing list pgsql-performance

From Jim Nasby
Subject Re: Query performance
Date
Msg-id 54CC327D.6000202@BlueTreble.com
Whole thread Raw
In response to Re: Query performance  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Query performance
List pgsql-performance
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).
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: working around JSONB's lack of stats?
Next
From: Jim Nasby
Date:
Subject: Re: Autocompletion with full text search