Re: Purging few months old data and vacuuming in production

Поиск
Список
Период
Сортировка
От Ranjith Paliyath
Тема Re: Purging few months old data and vacuuming in production
Дата
Msg-id SEZPR06MB5690F3A7AE31D9EA19DA0A28C2FB9@SEZPR06MB5690.apcprd06.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Purging few months old data and vacuuming in production  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Purging few months old data and vacuuming in production  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Thank you very much for the response.

    > Can you do online purging?

    > For example, get a list of the main table's primary keys to be deleted, and
    > then nibble away at them all day: in one transaction delete all the records
    > for one logically related set of records.  Do that N million times, and
    > you've purged the data without impacting production.

So, with this approach, is the advantage like, manual vacuuming worry may be set aside, because auto-vacuuming would
dealwith the dead rows? This is because the deletion step is executed record by record in main table, with its
connectedrecord(s) delete executions in rest of tables? Due to the infra capability that is there in this instance, the
impactcould be almost none!!?? 

Thank you...

This electronic mail (including any attachment thereto) may be confidential and privileged and is intended only for the
individualor entity named above. Any unauthorized use, printing, copying, disclosure or dissemination of this
communicationmay be subject to legal restriction or sanction. Accordingly, if you are not the intended recipient,
pleasenotify the sender by replying to this email immediately and delete this email (and any attachment thereto) from
yourcomputer system...Thank You. 



В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Purging few months old data and vacuuming in production
Следующее
От: Ron
Дата:
Сообщение: Re: Purging few months old data and vacuuming in production