[GENERAL] Problems reading dump files coming from version 7.1 into version 8.1.

2006-01-06 Thread Dumortier
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]  

[GENERAL] PostGres is not using indices in select, I would like it tobecause it is too slow !

2001-09-27 Thread Dominique Dumortier
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,