Re: [GENERAL] searching using indexes 8.3

2008-03-10 Thread Alban Hertroys
On Mar 10, 2008, at 6:33 PM, LARC/J.L.Shipman/jshipman wrote: Hi, When I do a search such as: EXPLAIN ANALYZE SELECT * FROM itemsbyauthor; QUERY PLAN --

Re: [GENERAL] searching using indexes 8.3

2008-03-10 Thread Alan Hodgson
On Monday 10 March 2008, LARC/J.L.Shipman/jshipman <[EMAIL PROTECTED]> wrote: > Hi, > When I do a search such as: > > EXPLAIN ANALYZE SELECT * FROM itemsbyauthor; > QUERY PLAN > ---

Re: [GENERAL] searching using indexes 8.3

2008-03-10 Thread Richard Huxton
LARC/J.L.Shipman/jshipman wrote: EXPLAIN ANALYZE SELECT * FROM itemsbyauthor; QUERY PLAN --- Seq Scan on itemsbyauthor (cost=0.0