Re: [PERFORM] Tablespaces and query planning

2012-06-11 Thread Albe Laurenz
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.

Re: [PERFORM] Tablespaces and query planning

2012-06-08 Thread Cédric Villemain
> - 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

[PERFORM] Tablespaces and query planning

2012-06-08 Thread Albe Laurenz
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