Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 24AA4633882 for ; Sat, 29 May 2010 23:33:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 28803-08 for ; Sun, 30 May 2010 02:33:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id 86D9562D9D2 for ; Sat, 29 May 2010 23:33:16 -0300 (ADT) Received: from [192.168.0.105] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis) id 0MYJ7N-1On3kH44Uz-00V3By; Sun, 30 May 2010 04:33:13 +0200 Message-ID: <4C01CE67.8010709@2ndquadrant.com> Date: Sat, 29 May 2010 22:33:11 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Explain docs and the regression database Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1/Di1TMy4dkz9gKcT+lMD0kwpnrRPhY2VSBbr3 8ux0vVVmzfw/0p4YczR6H+OxzWAscQzLVRD5coYzNCeCuHkqr5 HK1q+7/hLbKDRkR2bXz1MdQcKD5HbZj X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201005/64 X-Sequence-Number: 5561 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