Thanks for the help. I think we're only going to support pg 8.4 onwards. I'll
turn off the application's manual vacuuming and just let autovac do its thing.
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Monday, March 21, 2011 9:13 PM
To:
expected that
autovac would pick these changes up and run anyway?
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Friday, March 18, 2011 8:36 AM
To: Voils, Steven M
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Primary key vs unique index
Autovacuum is
, 2011 6:31 PM
To: Voils, Steven M
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Primary key vs unique index
On Thu, Mar 17, 2011 at 12:59 PM, Voils, Steven M
wrote:
> Thanks for the reply. I should have mentioned in the first post that we do
> delete significant amounts of the
To: Voils, Steven M
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Primary key vs unique index
On Mar 17, 2011, at 6:19 AM, Voils, Steven M wrote:
> Is there a fundamental difference between a primary key and a unique index?
> Currently we have primary keys on tables that have sig
]
Sent: Thursday, March 17, 2011 2:52 PM
To: Voils, Steven M
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Primary key vs unique index
On Thu, Mar 17, 2011 at 12:51 PM, Scott Marlowe wrote:
> On Thu, Mar 17, 2011 at 6:19 AM, Voils, Steven M
> wrote:
>> Is there a fundamenta
Is there a fundamental difference between a primary key and a unique index?
Currently we have primary keys on tables that have significant amounts of
updates performed on them, as a result the primary key indexes are becoming
significantly bloated. There are other indexes on the tables that al
