Re: Very long deletion time on a 200 GB database

Поиск
Список
Период
Сортировка
От Reuven M. Lerner
Тема Re: Very long deletion time on a 200 GB database
Дата
Msg-id 4F49E031.7080605@lerner.co.il
обсуждение исходный текст
Ответ на Re: Very long deletion time on a 200 GB database  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Hi, everyone.  Jeff wrote:
>
> Is this 9 hours run time for deleting one day worth of data, or for
> deleting the entire accumulation of cruft that filled up the hard
> drive in the first place (which would be 170 days, if you have 200GB
> that accumulated at 1GB per day and you only need 30 days) ?

Unfortunately, it took 9 hours to delete all of the rows associated with
the older-than-30-days records.

Reuven
--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?
Следующее
От: Wales Wang
Дата:
Сообщение: Re： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?