Thread: Problem setting custom auto-vaccum settings

Problem setting custom auto-vaccum settings

From
"Benjamin Krajmalnik"
Date:
I hae a set of tables which are quite large and which only have records
inserted into them.
The size of the tables (which are partitioned tables) reach 2-3GB (data
only) plus indices.

I decided to exclude them from the auto-vacuum process, since I
identified that I was having performance issues when these were being
autovacuumed.

I went to the vacuum settings tabs, clicked on the "Custom Settings"
checkbox, and unchecked the enabled checkbox.
So far so good.  Pressed OK, no error.

Now, if I try to make a change, I am getting the following error:

Column "base_scale_factor" of relation "pg_autovacuum" does not exist.

I am running pgAdmin 1.4.2 against PostgreSQL 8.1.4, both on Windows.


Re: Problem setting custom auto-vaccum settings

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Benjamin Krajmalnik
> Sent: 20 July 2006 21:26
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Problem setting custom auto-vaccum settings
>
> I hae a set of tables which are quite large and which only
> have records
> inserted into them.
> The size of the tables (which are partitioned tables) reach
> 2-3GB (data
> only) plus indices.
>
> I decided to exclude them from the auto-vacuum process, since I
> identified that I was having performance issues when these were being
> autovacuumed.
>
> I went to the vacuum settings tabs, clicked on the "Custom Settings"
> checkbox, and unchecked the enabled checkbox.
> So far so good.  Pressed OK, no error.
>
> Now, if I try to make a change, I am getting the following error:
>
> Column "base_scale_factor" of relation "pg_autovacuum" does not exist.
>
> I am running pgAdmin 1.4.2 against PostgreSQL 8.1.4, both on Windows.

Thanks - I've committed a fix to SVN. Would you like an updated .exe to
test?

Regards, Dave.