Big delete on big table... now what?

Поиск
Список
Период
Сортировка
От Fernando Hevia
Тема Big delete on big table... now what?
Дата
Msg-id 042c01c90496$ca8725f0$8f01010a@iptel.com.ar
обсуждение исходный текст
Ответы Re: Big delete on big table... now what?
Re: Big delete on big table... now what?
Список pgsql-performance
Hi list.

I have a table with over 30 million rows. Performance was dropping steadily
so I moved old data not needed online to an historic table. Now the table
has about 14 million rows. I don't need the disk space returned to the OS
but I do need to improve performance. Will a plain vacuum do or is a vacuum
full necessary?
¿Would a vacuum full improve performance at all?

Thanks for your hindsight.
Regards,

Fernando.


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