On Wed, Mar 26, 2008 at 01:23:22PM -0500, Jeff Amiel wrote: > explain analyze select * from table_a; > "Seq Scan on table_a (cost=100000000.00..100000001.02 rows=19 > width=103) (actual time=0.007..0.012 rows=19 loops=1)" > "Total runtime: 0.040 ms" > > any ideas? Looks like you've "disabled" seqscans. Because seqscan is a fallback method all disabling does is to make it very expensive. To check: SHOW enable_seqscan; If it's set then have a look in the config file, or maybe reset the per-role setting using ALTER ROLE[1]. Sam [1] http://www.postgresql.org/docs/current/static/sql-alterrole.html -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general