agora inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Jim Nasby <Jim.Nasby@BlueTreble.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
To: Joe Van Dyk <joe@tanga.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Query performance
Date: Fri, 30 Jan 2015 19:40:13 -0600
Message-ID: <54CC327D.6000202@BlueTreble.com> (raw)
In-Reply-To: <CAFj8pRDm92FvgzNEE7VMqYbhijXgOy6geY-xcGkey1mM7qoq6A@mail.gmail.com>
References: <CACfv+pKyJWGcU9DjmL3QAkUcb2cUHb-0sqODmjFt-hC9=k2+Kg@mail.gmail.com>
<CACfv+pJ3GGqm+uwqDWMuZeEJbTp1cNZ5o+KLtPk8w_KNqCf5wg@mail.gmail.com>
<CACfv+p+-7d015+uNJewUttb68nmOioKD72xxr2f7dc5gBcOdKg@mail.gmail.com>
<CAFj8pRAg_VRwRaOBRwVMNtg8KQNs0W82i3EkCCj8_kNBtWtQ-w@mail.gmail.com>
<CACfv+pJEdGm9_VfQRDAKyLM=RQT95X_0QLx0XQi2T8HqMxXoZQ@mail.gmail.com>
<CAFj8pRCuz6fvexXA3zaWTF36UROV+WdZqdOQeubhQ53Hyr-5PA@mail.gmail.com>
<CACfv+pJAMmk7kTFnCU6gVCZY4Q5Fz71T+o_CYw7Zha4v-pSO+w@mail.gmail.com>
<CAFj8pRDm92FvgzNEE7VMqYbhijXgOy6geY-xcGkey1mM7qoq6A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
view thread (48+ messages) latest in thread
Message-ID: <54CC327D.6000202@BlueTreble.com>
Permalink: ../54CC327D.6000202@BlueTreble.com/
Also on: postgresql.org/message-id/54CC327D.6000202@BlueTreble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Jim.Nasby@BlueTreble.com, pavel.stehule@gmail.com, joe@tanga.com
Subject: Re: Query performance
In-Reply-To: <54CC327D.6000202@BlueTreble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox