> When's the last time you analyzed this table? And a few hours before I posted this. vacuumdb --analyze also runs every night. > have you considered > running the pg_autovacuum daemon, which will vacuum > and analyze for you > in the back ground? We are using postgresql 7.3.2 which doesn't have autovacuum. Eugene __________________________________ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster