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.
