am wondering if I need to move to 8.1,
may be I could stick to 7.3 which apparently would read the 7.1 dump files.
Dr Dominique DUMORTIER
LASH-ENTPE
rue Maurice Audin
69518 Vaulx-en-Velin, Cedex
Tél: +33 (0)4 72 04 70 87
Fax: +33 (0)4 72 04 70 41
email: [EMAIL PROTECTED]
es such as the ones above.
The index is created like that:
CREATE INDEX ci_index on city (cix,ciy)
If I do select ciname from city where cix=400 and ciy=500;
This version of Postgres does not use the index and it takes much more time
than the previous version.
Hint: for the same couple cix,