Skip site navigation (1) Skip section navigation (2)

Re: PATCH: Update autovacuum (for TOAST-TABLE) to use reloptions, instead of a system catalog

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: Update autovacuum (for TOAST-TABLE) to use reloptions, instead of a system catalog
Date: 2009-02-24 09:43:52
Message-ID: 937d27e10902240143q3a752a66l4ff72be68ea20878@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Tue, Feb 24, 2009 at 9:00 AM, Ashesh Vashi
<ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
> Hi Dave,
>
> Please find the patch for (TOAST-TABLE) autovacuum settings.
>
> Patch contains changes for:
> * Moved the code related to fetching the (Toast-Table) AutoVaccum settings
> from dlgTable to pgTable.
> * Showing AV settings (also the Toast-Table AV settings, if present) in the
> properties listview.
> * pgTable::GetSql() will now show custom AV settings for toast tables.
>
Hi Ashesh,

I think there is a little misunderstanding.

With variables on roles and databases, if one is set, we add it to the
properties list as an item on it's own, e.g.

add_missing_from    on
log_statement      all

With tables, I think we should isplay the AV reloptions similarly *if*
they are set, eg.

autovacuum_enabled    Yes
autovacuum_analyze_threshold   150
toast.autovacuum_enabled    Yes
toast.autovacuum_vacuum_cost_limit     25

Can you tweak the patch accordingly please?

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

In response to

Responses

pgadmin-hackers by date

Next:From: Ashesh D VashiDate: 2009-02-24 10:00:21
Subject: Re: PATCH: Update autovacuum (for TOAST-TABLE) to use reloptions, instead of a system catalog
Previous:From: Quan ZongliangDate: 2009-02-24 09:23:26
Subject: Import: empty string and expression

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group