Re: Primary key vs unique index

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Primary key vs unique index
Дата
Msg-id AANLkTimahi1BkR9qmHVtGQkKuN2Y5i3vAM1aM5zJyvEM@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Primary key vs unique index  ("Voils, Steven M" <steve@sensorswitch.com>)
Ответы Re: Primary key vs unique index  ("Voils, Steven M" <steve@sensorswitch.com>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "Francisco Figueiredo Jr."
Дата:
Сообщение: 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...
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Windows ODBC connection trouble? ISP issue?