Ben Chobot <bench@xxxxxxxxxxxxxxx> writes: > 4. What might cause autovacuum analyze to make an index perform worse immediately, when a manual vacuum analyze does not have the same affect? And I'm not talking about changing things so the planner doesn't use the index, but rather, having the index actually take longer. Dunno about the replication angle, but would this have been a GIN index? I'm wondering about possible interference with flushing of its pending-insert queue (the FASTUPDATE stuff). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
