On Fri, Jul 06, 2012 at 09:07:53AM -0700, rverghese wrote: > We are experiencing a similar problem, even though we are on 8.4 and have > been for a while, and have autovacuum turned on. I have regular concurrent > reindexes on the indexes but the primary key is seriously bloated. I was > considering doing the same thing, that is, create another primary key that > is built on a sequence ( primarily for slony) and then change my current > multi-column primary key to a unique index. Have you been able to work > around the problem in any other way? http://www.depesz.com/2011/07/06/bloat-happens/ depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
