Tablespaces and query planning

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Tablespaces and query planning
Date: 2012-06-08 08:15:18
Message-ID: D960CB61B694CF459DCFB4B0128514C207F8154E@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Albe Laurenz 2012-06-08 09:58:30 Re: Seqscan slowness and stored procedures
Previous Message Robert Klemme 2012-06-07 11:48:28 Re: Multiple Concurrent Updates of Shared Resource Counter