On Tue, Aug 15, 2006 at 10:14:49AM +0300, Andrii Vasyliev wrote: > Hi! > > I have a database just recreated from scratch with SQL script. > (My PostgreSQL version is 8.1.3). > All of the tables are pretty empty, but that's what I've got with explain: > > EXPLAIN SELECT * FROM account; > QUERY PLAN > ------------------------------------------------------------------------ > Seq Scan on account (cost=100000000.00..100000001.05 rows=5 width=41)
Looks like someone did an "enable_seqscan=no" somewhere, do a "show all" and check the planner variables... Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
