Postgres Pro
Downloads
Home   >   mailing lists

Re: Primary key vs unique index - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Primary key vs unique index
Date
Msg-id AANLkTimahi1BkR9qmHVtGQkKuN2Y5i3vAM1aM5zJyvEM@mail.gmail.com
Whole thread Raw
In response to Re: Primary key vs unique index  ("Voils, Steven M" <steve@sensorswitch.com>)
Responses Re: Primary key vs unique index  ("Voils, Steven M" <steve@sensorswitch.com>)
List pgsql-general
Tree view 
On Thu, Mar 17, 2011 at 12:59 PM, Voils, Steven M
<steve@sensorswitch.com> wrote:
> Thanks for the reply.  I should have mentioned in the first post that we do delete significant amounts of the table
whichI thought was the cause of the bloat.  We are already performing automatic vacuums nightly. 

Automatic regular vacuums?  So you do or don't have autovac turned on?

What version of pg are you running (8.3 or before, 8.4 or later?)

Are your nightly vacuums FULL or regular vacuums?

pgsql-general by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...
Next
From: Adrian Klaver
Date:
Subject: Re: Windows ODBC connection trouble? ISP issue?