Re: [PERFORM] Query plan changing when queried data does not

2006-12-18 Thread Tom Lane
"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

[PERFORM] Query plan changing when queried data does not

2006-12-18 Thread Harry Hehl
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