Re: Performance degredation at client site

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Bill Chandler" <billybobc1210(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance degredation at client site
Date: 2005-01-31 18:14:48
Message-ID: opslhbmydnth1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Chandler 2005-01-31 18:32:00 Re: Performance degredation at client site
Previous Message Tom Lane 2005-01-31 17:46:19 Re: Performance degredation at client site