Re: [HACKERS] psql nested queries with 2000+ records

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(at)hill-b-073(dot)resnet(dot)purdue(dot)edu