Re: Problem setting custom auto-vaccum settings - Mailing list pgadmin-support

From Dave Page
Subject Re: Problem setting custom auto-vaccum settings
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40154C0F7@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Problem setting custom auto-vaccum settings  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgadmin-support

> -----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.


pgadmin-support by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Problem setting custom auto-vaccum settings
Next
From: Devrim GUNDUZ
Date:
Subject: New RPM schema