Re: Performance degredation at client site - Mailing list pgsql-performance

From PFC
Subject Re: Performance degredation at client site
Date
Msg-id opslhbmydnth1vuj@musicbox
Whole thread Raw
In response to Performance degredation at client site  (Bill Chandler <billybobc1210@yahoo.com>)
List pgsql-performance
> 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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance degredation at client site
Next
From: Bill Chandler
Date:
Subject: Re: Performance degredation at client site