VACUUM Performance

Поиск
Список
Период
Сортировка
От Steve Oualline
Тема VACUUM Performance
Дата
Msg-id 00C5463E8A5F7C41A8396D701A6734B1527A62@mail01.stbernard.com
обсуждение исходный текст
Ответы Re: VACUUM Performance
Список pgsql-performance

Question:   I have a big table with 120,000,000 records.

Let's assume that I DELETE 4,000,000 records, VACUUM FULL, and REINDEX.

Now I have the same table, but with 240,000,000 records.

I DELETE 8,000,000 records, VACUUM FULL, and REINDEX.

Should the second operation with twice the data take twice the time as the first?

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

Предыдущее
От: alvis
Дата:
Сообщение: Re: New hardware thoughts
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: Is ODBC that slow?