Tablespaces and query planning - Mailing list pgsql-performance

From Albe Laurenz
Subject Tablespaces and query planning
Date
Msg-id D960CB61B694CF459DCFB4B0128514C207F8154E@exadv11.host.magwien.gv.at
Whole thread Raw
Responses Re: Tablespaces and query planning  (Cédric Villemain <cedric@2ndquadrant.com>)
List 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 by date:

Previous
From: Robert Klemme
Date:
Subject: Re: Multiple Concurrent Updates of Shared Resource Counter
Next
From: "Albe Laurenz"
Date:
Subject: Re: Seqscan slowness and stored procedures