From: PFC <lists@boutiquenumerique.com>
To: Bill Chandler <billybobc1210@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Performance degredation at client site
Date: Mon, 31 Jan 2005 19:14:48 +0100
Message-ID: <opslhbmydnth1vuj@musicbox> (raw)
In-Reply-To: <20050131171918.20665.qmail@web51410.mail.yahoo.com>
References: <20050131171918.20665.qmail@web51410.mail.yahoo.com>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@boutiquenumerique.com, billybobc1210@yahoo.com
Subject: Re: Performance degredation at client site
In-Reply-To: <opslhbmydnth1vuj@musicbox>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox