From: | "Voils, Steven M" <steve(at)sensorswitch(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(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-18 12:38:30 |
Message-ID: | 856778F98E4F4B4F896F2B70C8164A3437FA9D84BE@EXCHANGE-MBX2.AcuityLightingGroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What are the general guidelines under which autovacuum will trigger? I was unaware it was turned on by default for the newer versions. Would it be worthwhile to leave the manual vacuuming on? Currently it runs immediately after large sections of the tables are deleted. Or would it be expected that autovac would pick these changes up and run anyway?
-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, March 18, 2011 8:36 AM
To: Voils, Steven M
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Primary key vs unique index
Autovacuum is generally more effective as it can run when it needs to
not having to wait til the end of the day. If you delete big chunks
several times a day autovac can keep up. Also, it's enabled by
default in 8.4 and up so the end user would have to actively turn it
off in this instance.
On Fri, Mar 18, 2011 at 6:21 AM, Voils, Steven M <steve(at)sensorswitch(dot)com> wrote:
> Our application supports pg 8.4 onwards. The vacuums are run automatically by the application rather than requiring end users to enable autovacuum; the vacuums being performed are regular.
>
> -----Original Message-----
> From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
> Sent: Thursday, March 17, 2011 6:31 PM
> To: Voils, Steven M
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Primary key vs unique index
>
> 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?
>
--
To understand recursion, one must first understand recursion.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Figueiredo Jr. | 2011-03-18 13:44:15 | Re: [GENERAL] 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... |
Previous Message | Geoffrey Myers | 2011-03-18 12:36:46 | error messages during restore |