Explain docs and the regression database
The introduction to using EXPLAIN:
http://developer.postgresql.org/pgdocs/postgres/using-explain.html
includes a footnote at the bottom suggesting you might follow along with
these examples because they come from the regression test database.
This would really be a lot more useful if it gave some sort of clue just
how exactly a user might get that database populated with that
regression data. I'm not even quite sure myself exactly what point in
the regression testing cycle these examples came from. Another open
question in my head is whether enough pieces of the regression set are
shipped in the most common packaging sets that it's ever practical to
expect users to run the tests at all. Thoughts?
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
Greg Smith <greg@2ndquadrant.com> writes:
The introduction to using EXPLAIN:
http://developer.postgresql.org/pgdocs/postgres/using-explain.html
includes a footnote at the bottom suggesting you might follow along with
these examples because they come from the regression test database.
This would really be a lot more useful if it gave some sort of clue just
how exactly a user might get that database populated with that
regression data.
You run the regression tests.
I'm not even quite sure myself exactly what point in
the regression testing cycle these examples came from.
The ending state.
Another open
question in my head is whether enough pieces of the regression set are
shipped in the most common packaging sets that it's ever practical to
expect users to run the tests at all. Thoughts?
In Fedora/RHEL, and I believe also the PGDG RPMs, you'd install the
postgresql-test RPM and run it per directions.
regards, tom lane
Tom Lane wrote:
Greg Smith <greg@2ndquadrant.com> writes:
The introduction to using EXPLAIN:
http://developer.postgresql.org/pgdocs/postgres/using-explain.html
includes a footnote at the bottom suggesting you might follow along with
these examples because they come from the regression test database.
This would really be a lot more useful if it gave some sort of clue just
how exactly a user might get that database populated with that
regression data.You run the regression tests.
FYI, I think you have to run 'installcheck' so the database remains
after the regression tests.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com