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 по дате отправления:

Предыдущее
От: pgsql-performance@ian.org
Дата:
Сообщение: Re: Why do my hash joins turn to nested loops?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Big delete on big table... now what?