Tablespaces and query planning

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Tablespaces and query planning
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C207F8154E@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответы Re: Tablespaces and query planning  (Cédric Villemain <cedric@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Klemme
Дата:
Сообщение: Re: Multiple Concurrent Updates of Shared Resource Counter
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Seqscan slowness and stored procedures