Re: BYTEA index - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: BYTEA index
Date
Msg-id 20110604150940.4ec3342f@anubis.defcon1
Whole thread Raw
In response to Re: BYTEA index  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-novice
On Fri, 3 Jun 2011 23:01:10 -0400, Josh Kupershmidt <schmiddy@gmail.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
...

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: encryption+compression
Next
From: Saqib Ilyas
Date:
Subject: Error near delete in plpgsql function