Hi, I have a very big dbase. czw@newage:~/prog$ psql mamhist -t -q -c "select count(*) from entry;" 10679609 The table size is -rw------- 1 postgres postgres 2133843968 Jul 7 11:15 entry My problem: czw@newage:~/prog$ psql mamhist -t -q -c "select * from entry where radi='500688' and dateacnt >19980915;" ERROR: cannot open segment 1 of relation entry ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Why? ps. OS: debian/potato, libc6 2.1.1-10, postgres 6.4.2-8 all packages installed from .deb -- CZW
