Re: SELECT * FROM table is too slow

Поиск
Список
Период
Сортировка
От Guillaume Cottenceau
Тема Re: SELECT * FROM table is too slow
Дата
Msg-id 877ii1ylld.fsf@mnc.ch
обсуждение исходный текст
Ответ на Re: SELECT * FROM table is too slow  ("Luiz K. Matsumura" <luiz@planit.com.br>)
Список pgsql-performance
"Luiz K. Matsumura" <luiz 'at' planit.com.br> writes:

> If we run the commands "vacumm full analyze"

If you're using the cost based vacuum delay, don't forget that it
will probably take long; possibly, you may deactivate it locally
before running VACUUM FULL, in case the locked table is mandatory
for your running application(s).

--
Guillaume Cottenceau, MNC Mobile News Channel SA

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Making the most of memory?
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Re: Workaround for cross column stats dependency