On Wed, Feb 18, 2009 at 7:45 AM, Ashesh Vashi <ashesh.va...@enterprisedb.com> wrote: > Hi All, > > Please find the attached patch for "Update autovacuum to use reloptions, > instead of a system catalog".
Thanks - patch applied. > In "CREATE/ALTER TABLE", it also supports for toast.autovacuum* settings (as > storage parameters), > which I have not implemented currently. > Do we need to give support for that? > And if yes, If you can add it in the next few days, then I think yes. > 1. Which documents I need to read for that? http://developer.postgresql.org/pgdocs/postgres/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS ? It all looks pretty much the same as the work you've done though. > 2. From which catalog tables, I can get the toast.autovacuum* settings. I assume they go in pg_class.reloptions for the owner table. It should be easy to test that. > 3. How UI should look like? Good question. What about having a tabset under the 'Custom Autovacuum' checkbox, and have one page that shows the existing options for the table, and one that shows the TOAST options? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
