"Harry Hehl" <[EMAIL PROTECTED]> writes:
> Why does vacuum full and reindex make a difference if the 3 tables are
> never updated or records deleted?
Probably because you did an ANALYZE somewhere and updated the planner's
stats. I think your major problem is poor estimation of the ds_tables
resul
I have a database that has 3 tables with a relatively small number of
records in each. (see schema/counts below). These 3 tables are loaded
when the db is created and there are never any updates or deletes on the
3 tables. This database does have many other tables.
ds_tables 132 rows, ds_types