Skip site navigation (1) Skip section navigation (2)

Re: BYTEA index

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: BYTEA index
Date: 2011-06-04 13:09:40
Message-ID: 20110604150940.4ec3342f@anubis.defcon1 (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Fri, 3 Jun 2011 23:01:10 -0400, Josh Kupershmidt <schmiddy(at)gmail(dot)com> wrote:

> Well, you *could* create a partial index which only covered the NULL
> values, if you think such an index would actually be useful (i.e. you
> have a lot of queries looking for NULL values in this table).

Ok that what I tought; but I'm gonna stick to BYTEA NULL values indexation
only 'cos this table is heavy already (goal is just to check whether an
invoice's PDF has been created or not.)

Thanks Josh

In response to

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2011-06-04 14:39:58
Subject: encryption+compression
Previous:From: Josh KupershmidtDate: 2011-06-04 03:01:10
Subject: Re: BYTEA index

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group