"Vilson farias" <vilson.farias@digitro.com.br> writes:
> I've been testing hardly and now I found something interesting : these
> errors only happen when model/data are imported with pg_dump help, that is,
> all indexed fields are sequencially scanned when I do a select from some
> pk-indexed table, but if model/data where created/imported without pg_dump,
> then everything works fine. Does anyone know why this is happening?
Have you done a VACUUM ANALYZE after loading the pg_dump output?
It looks to me like the planner may not have statistics about the table...
regards, tom lane
