Tablespaces and query planning

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Tablespaces and query planning
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C207F8154E@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответы Re: Tablespaces and query planning
Список pgsql-performance
Could somebody confirm or refute the following statements, please?

- The statistics gathered by ANALYZE are independent of the tablespace
  containing the table.
- The tablespace containing the table has no influence on query planning
  unless seq_page_cost or random_page_cost has been set on the
tablespace.
- VACUUM ANALYZE does the same as VACUUM followed by ANALYZE.

Yours,
Laurenz Albe

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