| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Yves F. Barbier | 2011-06-04 14:39:58 | encryption+compression |
| Previous Message | Josh Kupershmidt | 2011-06-04 03:01:10 | Re: BYTEA index |