> Do I understand correctly, however, that when you
> create a unique SERIAL column an index is
> automatically created on that column? If so, does
> that sound like a possible culprit? We are not doing
> any reindexing on that index at all. Could it be
> suffering from index bloat? Do we need to
> periodically explicity run the command:
SERIAL creates a sequence, not an index.
UNIQUE and PRIMARY KEY do create indexes.
Regards.