Re: [GENERAL] seq-scan or index-scan

2012-07-04 Thread Andreas Kretschmer
Tom Lane wrote: > Andreas Kretschmer writes: > > production=*# explain analyse select * from boxes; > > QUERY PLAN > > --- > > Seq Scan o

Re: [GENERAL] seq-scan or index-scan

2012-07-03 Thread Tom Lane
Andreas Kretschmer writes: > production=*# explain analyse select * from boxes; > QUERY PLAN > --- > Seq Scan on boxes (cost=0.00..990783.

Re: [GENERAL] seq-scan or index-scan

2012-07-03 Thread Tomas Vondra
On 3 Červenec 2012, 17:58, Andreas Kretschmer wrote: > Dear list, > > i have a table and i'm selecting all records without a where-condition, > and i don't need a ORDER BY: > > > > production=*# explain analyse select * from boxes; > QUERY PLAN > --

[GENERAL] seq-scan or index-scan

2012-07-03 Thread Andreas Kretschmer
Dear list, i have a table and i'm selecting all records without a where-condition, and i don't need a ORDER BY: production=*# explain analyse select * from boxes; QUERY PLAN --