The examples given in Chapter 14 are not true.

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема The examples given in Chapter 14 are not true.
Дата
Msg-id 171673189739.2021727.14284698255790538307@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: The examples given in Chapter 14 are not true.
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/performance-tips.html
Description:

1) How did you create the `tenk1` table? If you will claim that from the
source code of version 9.3, the question arises how CREATE TABLE tenk1 (...)
WITH OIDS; in v16?


https://github.com/postgres/postgres/blob/524440579f838b30579f35d2045cc01b6f5070d8/src/test/regress/sql/create_table.sql#L37

Additionally, you have to spend time searching for additional and completely
unnecessary information and old versions of the code, although you have just
installed server version 16 from the source code, which has passed all
checks - but as it turns out is not compatible with the documentation.

After `make installcheck` v16 - All 215 tests passed. But 

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`.
3) How do you see this familiarization with the product through
documentation that points to older versions that work very differently in
the new version?

В списке pgsql-docs по дате отправления:

Предыдущее
От: jian he
Дата:
Сообщение: Re: Add small detail to RAISE statement descripton
Следующее
От: Tom Lane
Дата:
Сообщение: Re: The examples given in Chapter 14 are not true.