From: =?iso-8859-1?q?C=E9dric_Villemain?= <cedric@2ndquadrant.com>
Reply-To: cedric@2ndquadrant.com
Organization: 2ndQuadrant
To: pgsql-performance@postgresql.org
Subject: Re: Tablespaces and query planning
Date: Fri, 8 Jun 2012 12:36:03 +0200
User-Agent: KMail/1.13.7 (Linux/3.2.0-2-amd64; KDE/4.7.4; x86_64; ; )
Cc: "Albe Laurenz" <laurenz.albe@wien.gv.at>
References: 
 <D960CB61B694CF459DCFB4B0128514C207F8154E@exadv11.host.magwien.gv.at>
In-Reply-To: 
 <D960CB61B694CF459DCFB4B0128514C207F8154E@exadv11.host.magwien.gv.at>
MIME-Version: 1.0
Content-Type: multipart/signed; boundary="nextPart5380226.gKoWLzR5V5";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <201206081236.08512.cedric@2ndquadrant.com>

--nextPart5380226.gKoWLzR5V5
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

> - 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 VACUUM followed by ANALYZE.

no.
it is fine grained, but in the diffs there is:

 VACUUM and ANALYSE do not update pg_class the same way for the=20
reltuples/relpages: for ex VACUUM is accurate for index, and ANALYZE is fuz=
zy=20
so if you issue a vacuum you have exact values, if you then run ANALYZE you=
=20
may change them to be less precise.

=2D-=20
C=E9dric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - D=E9veloppement, Expertise et Formation

--nextPart5380226.gKoWLzR5V5
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iQEcBAABAgAGBQJP0dWTAAoJENsgH0yzVBebecUIAJBi58W5FU2gZMz3h+3o6VHg
/erxCyR8fhhXMtdY8CVN8FvawlbKRVkqDuuz+d2mkwJBZw/+aRlReGI7wqhkBxdI
eEXY4x/Eid7lWkbZB1EOx+br3mOjB3NtZyVX8tb1titKbFduqXsFSdbsN8LRrfGA
9Sf82wRaY1hGQ9qQX23tpgt9vl1r++UR9Ssn0aHAN/V3uUzguYbK0s6dRSl+CoJV
wJFjXKfaaG6aaTGBq0df+y2kSmRLRAg3DiCgX0uQ+lWuxrUPs8j1+okUFOuZTx3c
tXhyD6qWmHL/WbVWVR6h8LEv3WaUaoFrIw2IA+Kqt99RemXztt/Ug+X5HA5hJrA=
=dtVu
-----END PGP SIGNATURE-----

--nextPart5380226.gKoWLzR5V5--