Aparently, the postgresql server was moved from the BSDI box to a linux
2.0.30 box, so the numbers that where given where not from the bsdi box. So
now I am doing the queries personally. I'm sorry for the run around.
This is the responce from the explain on the BSDI 3.1 box.
amusements=> explain select name from games where name in (select name from
game
s where name like 'A%');
NOTICE: QUERY PLAN:
Seq Scan on games (cost=0.00 size=0 width=12)
SubPlan
-> Seq Scan on games (cost=0.00 size=0 width=12)
EXPLAIN
amusements=> explain select name from games where name in (select name from
game
s2 where mfr = '');
NOTICE: QUERY PLAN:
Seq Scan on games (cost=0.00 size=0 width=12)
SubPlan
-> Seq Scan on games2 (cost=0.00 size=0 width=12)
EXPLAIN
amusements=> explain select * from games where mfr = '';
NOTICE: QUERY PLAN:
Seq Scan on games (cost=0.00 size=0 width=160)
EXPLAIN
Once again, I appologize for this misinformation and hope this sheds some
light to the original problem. I'm making a note to change permissions on
who can do what from now on.
On a side note, the query was done on the 2.0.30 box in 5 minutes compared
to the BSDI box at 15+.
-Coronach@hill-b-073.resnet.purdue.edu