| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | indexing of INT8 ? |
| Date: | 2001-08-01 04:40:17 |
| Message-ID: | 20010801064017.5603eba5.depesz@depesz.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hi
i just checked a friends database and it seems that INT8 fields are not
indexable.
i mean:
he has a table with several fields. one of this fields is int8 with unique
index.
we have aproximately 100000 records in this table, database is vacuumed, but
the index doesn't seem to work when i do something like
explain select * from table where int8field = xxxx;
is it known bug of 7.1.2 or is something wrong with the database?
depesz
--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
... and the end of all our exploring will be to arrive where we started
and know the place for the first time. -- T. S. Eliot
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Turner | 2001-08-01 04:48:50 | Re: How to upgrade under redhat [was: alter user to change user's password returns pg_shadow: Permission |
| Previous Message | Tom Lane | 2001-08-01 04:03:13 | Re: Finding number of current connections |