Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Bill ChandlerDate: 2005-01-31 18:32:00
Subject: Re: Performance degredation at client site
Previous:From: Tom LaneDate: 2005-01-31 17:46:19
Subject: Re: Performance degredation at client site

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group