From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | y(dot)saburov(at)gmail(dot)com |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: The examples given in Chapter 14 are not true. |
Date: | 2024-05-26 14:35:34 |
Message-ID: | 2752.1716734134@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> Page: https://www.postgresql.org/docs/16/performance-tips.html
> 1) How did you create the `tenk1` table?
As the text says, it's supposed to be made by running the core
regression tests ("make installcheck").
> 1) relpages for table `tenk1` - different in version 16. Some calculations
> will be incorrect accordingly
> 2) you will not be able to reproduce examples for which there are no indexes
> in table `tenk1` - for example index `index_tenk1_on_four`.
Yeah, that's a bit out of date. I fixed it up awhile ago for v17:
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=5caa05749
However, the text also points out that you won't necessarily get
exactly the same results as are shown, for assorted reasons of
which different-version is only one. So I think these changes
were more neatnik-ism than rescuing the chapter from total
irrelevancy.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Marcel Hofstetter | 2024-05-28 12:15:15 | 17beta1 source download does not include docs & manpages |
Previous Message | PG Doc comments form | 2024-05-26 13:58:17 | The examples given in Chapter 14 are not true. |