Re: PATCH: Update autovacuum to use reloptions, instead of a system catalog
| От | Ashesh Vashi |
|---|---|
| Тема | Re: PATCH: Update autovacuum to use reloptions, instead of a system catalog |
| Дата | |
| Msg-id | 499C0C0D.7010000@enterprisedb.com обсуждение исходный текст |
| Ответ на | Re: PATCH: Update autovacuum to use reloptions, instead of a system catalog (Dave Page <dpage@pgadmin.org>) |
| Ответы |
Re: PATCH: Update autovacuum to use reloptions,
instead of a system catalog
PATCH: Update autovacuum (for TOAST-TABLE) to use reloptions, instead of a system catalog |
| Список | pgadmin-hackers |
Hi Dave Page,
And this table's reloptions contains the toast.autovacuum* settings.
other for the toast table?
Tabset under the 'Vacuum Settings' should do.
What do you say?
I will try to finish it by this end of week / Monday.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.
Yeah.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.
I need to find the TOAST table, if any.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.
And this table's reloptions contains the toast.autovacuum* settings.
Shouldn't we have two 'Custom Autovacuum' checkbox - one for the table and the3. 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?
other for the toast table?
Tabset under the 'Vacuum Settings' should do.
What do you say?
--
В списке pgadmin-hackers по дате отправления: