On Tue, Sep 29, 2009 at 9:48 AM, Bill Moran <wmo...@potentialtech.com> wrote: > There has (over the last few years) been a lot of speculation from people > who think that indexes may suffer performance degradation under some > workloads. I've yet to see any actual evidence. >
Just last week I reindexed a 70+ million row table and shaved about 50% of the bloated index pages on a two integer column index. I believe it hadn't been reindexed in about 6 months. I regularly have to re-index for performance purposes. My data lives on most tables for about 6 months and is then deleted, or lives forever and is updated frequently. I've commented about this many times before. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
