Re: [PERFORM] Tablespaces and query planning

Cédric Villemain wrote: - The statistics gathered by ANALYZE are independent of the tablespace containing the table. yes. - 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. yes.

[PERFORM] Tablespaces and query planning

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

Re: [PERFORM] Tablespaces and query planning

- The statistics gathered by ANALYZE are independent of the tablespace containing the table. yes. - 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. yes. - VACUUM ANALYZE does the same as