Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6F9F8650389; Wed, 13 Aug 2008 22:31:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46852-03-7; Wed, 13 Aug 2008 22:31:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id AD3DA6503AD; Wed, 13 Aug 2008 22:30:29 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m7E1UQGx021064; Wed, 13 Aug 2008 21:30:26 -0400 (EDT) To: Alvaro Herrera cc: pgsql-performance@postgresql.org, Pg Hackers Subject: Re: [HACKERS] autovacuum: use case for indenpedent TOAST table autovac settings In-reply-to: <20080814012834.GG4672@alvh.no-ip.org> References: <20080813212838.GA4683@alvh.no-ip.org> <18539.1218675190@sss.pgh.pa.us> <20080814012834.GG4672@alvh.no-ip.org> Comments: In-reply-to Alvaro Herrera message dated "Wed, 13 Aug 2008 21:28:34 -0400" Date: Wed, 13 Aug 2008 21:30:26 -0400 Message-ID: <21063.1218677426@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/163 X-Sequence-Number: 31044 Alvaro Herrera writes: > Tom Lane wrote: >> It seems like we'll want to do it somehow. Perhaps the cleanest way is >> to incorporate toast-table settings in the reloptions of the parent >> table. Otherwise dump/reload is gonna be a mess. > My question is whether there is interest in actually having support for > this, or should we just inherit the settings from the main table. My > gut feeling is that this may be needed in some cases, but perhaps I'm > overengineering the thing. It seems reasonable to inherit the parent's settings by default, in any case. So you could do that now and then extend the feature later if there's real demand. regards, tom lane