But, will it not create transaction wraparound for those table?Thanks.On Wed, Jan 20, 2016 at 4:44 PM, Melvin Davidson <melvin6925@gmail.com> wrote:ALTER TABLE your_schema.your_table SET (autovacuum_enabled = false, toast.autovacuum_enabled = false);On Wed, Jan 20, 2016 at 6:22 PM, AI Rumman <rummandba@gmail.com> wrote:Hi,I have a table with daily partition schema on Postgresql 9.1 where we are keeping 2 years of data.Often I experience that autovacuum process is busy with old tables where there is no change. How can I stop it?Please advice.Thanks.-- Melvin DavidsonI reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
ALTER TABLE your_schema.your_table SET (autovacuum_enabled = false, toast.autovacuum_enabled = false);On Wed, Jan 20, 2016 at 6:22 PM, AI Rumman <rummandba@gmail.com> wrote:Hi,I have a table with daily partition schema on Postgresql 9.1 where we are keeping 2 years of data.Often I experience that autovacuum process is busy with old tables where there is no change. How can I stop it?Please advice.Thanks.-- Melvin DavidsonI reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
Hi,I have a table with daily partition schema on Postgresql 9.1 where we are keeping 2 years of data.Often I experience that autovacuum process is busy with old tables where there is no change. How can I stop it?Please advice.Thanks.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных