On Fri, Nov 12, 2010 at 5:52 AM, Kenneth Marshall <ktm@xxxxxxxx> wrote: > > I cannot speak to your suggestion, but it sounds like you are not > vacuuming enough and a lot of the bloat/randomization would be helped > by making use of HOT updates in which the updates are all in the same > page and are reclaimed almost immediately. > > Regards, > Ken IIRC, HOT only operates on non-indexed columns, so if you the tables are heavily indexed you won't get the full benefit of HOT. I could be wrong though. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
