Vacuum Full - Questions

Поиск
Список
Период
Сортировка
От Patrick B
Тема Vacuum Full - Questions
Дата
Msg-id CAJNY3itdjFCr7v-uLUO=yHWj3A4L8TLFA=rtaF+wby7U0LSv5A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Vacuum Full - Questions
Re: Vacuum Full - Questions
Список pgsql-general
Hi guys,

A dev has ran a VACUUM FULL command into our test database running PostgreSQL 9.5 (I know... goddamn!!!!)...

... after the Vacuum Full, some queries start using SEQ scans instead of indexes...

Does that happen because of the size of the table? The table that I'm referring to is 150MB big after the vacuum (Before was 1G)...


Cheers
Patrick

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