Cleaning up some remarkably old stuff in installation.sgml

2019-08-28 Thread Tom Lane
While poking at the configure options list, I noticed that there is some other text in installation.sgml that is long past its sell-by date. For instance, the first para in install-requirements points to standalone FAQ documents that we removed back in 8.4. I don't think we need to have blow-by-bl

Re: Can we bring some organization to the configure options list?

2019-08-28 Thread Tom Lane
I wrote: > I was just noticing, while answering a user question, the amount of > unorganized urban sprawl we've accumulated in > https://www.postgresql.org/docs/devel/install-procedure.html > We've got practically-essential options like --prefix and > --with-openssl intermixed with obscure portabil

Re: Most-common value docs in PG 12

2019-08-28 Thread Tomas Vondra
On Wed, Aug 28, 2019 at 12:22:38PM -0400, Bruce Momjian wrote: Our docs for most-common values in PG 12 has: --> CREATE STATISTICS stts3 (mcv) ON state, city FROM zipcodes; ANALYZE zipcodes; SELECT m.* FROM pg_statistic_ext join pg_statistic_ext_data on (oid =

Most-common value docs in PG 12

2019-08-28 Thread Bruce Momjian
Our docs for most-common values in PG 12 has: --> CREATE STATISTICS stts3 (mcv) ON state, city FROM zipcodes; ANALYZE zipcodes; SELECT m.* FROM pg_statistic_ext join pg_statistic_ext_data on (oid = stxoid), pg_mcv_list_items(stxdmcv) m