On 29.11.2011 23:19, Tomas Vondra wrote: > Hi, > > what PostgreSQL version is this? That's the first thing we need to know. > > On 29.11.2011 22:28, Tyler Hains wrote: >> Yes, I'm pretty sure autovacuum is enabled. Changing the query as shown >> there uses the sub-optimal index. > > That doesn't mean Sorry, deleted this part by accident. It should be "That doesn't mean the table / index is not bloated." See my other posts for more details. Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general