| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Voils, Steven M" <steve(at)sensorswitch(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Primary key vs unique index |
| Date: | 2011-03-17 22:30:56 |
| Message-ID: | AANLkTimahi1BkR9qmHVtGQkKuN2Y5i3vAM1aM5zJyvEM@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 17, 2011 at 12:59 PM, Voils, Steven M
<steve(at)sensorswitch(dot)com> wrote:
> Thanks for the reply. I should have mentioned in the first post that we do delete significant amounts of the table which I 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2011-03-17 22:33:27 | Re: Windows ODBC connection trouble? ISP issue? |
| Previous Message | Francisco Figueiredo Jr. | 2011-03-17 22:26:38 | 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... |