Jim, > Keep in mind that if analyze has never been run on a table the database > will assume 1000 rows, which is definately off from 122 rows.
autovacuum processes this tabele regularly. I believed that autovacuum can update the row count to be real. > You might want to ask on the pgAdmin list. Though I'd recommend against > calling the guru 'stupid' over there. :) I'm creating application which upsizes existing data to new postgres 8.1 database. Will I need to run VACUUM ANALYZE after upsizing ? Must I enable statitics collection for this database ? Andrus. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
