Re: Joe Hellerstein's "Looking Back at Postgres" paper

2024-07-04 Thread Thomas Munro
On Fri, Jul 5, 2024 at 11:13 AM Tom Lane wrote: > Hmm, the arxiv.org copy claims it appeared in "Making Databases Work", > so that's how I cited it in the proposed patch. Is that wrong? > Perhaps it was published twice? No, you have it right, I confused myself with the subtitle. https://www.ama

Re: Joe Hellerstein's "Looking Back at Postgres" paper

2024-07-04 Thread Thomas Munro
On Thu, Jul 4, 2024 at 5:40 PM Tom Lane wrote: > I happened to come across this: > > https://arxiv.org/pdf/1901.01973 > > I found this to be really interesting reading, Just by the way, for anyone interested, that paper appeared as a chapter in a book "The Pragmatic Wisdom of Michael Stonebraker"

Re: [DOCS] The reference to 'atacontrol' on FreeBSD is outdated.

2023-11-21 Thread Thomas Munro
On Wed, Nov 22, 2023 at 2:12 PM Bruce Momjian wrote: > On Sat, Aug 12, 2017 at 10:47:00PM +0100, John Ekins wrote: > > Sure. Camcontrol does indeed cover IDE, SCSI and SAS drives. > > > > Replace this line: > > On FreeBSD, IDE drives can be queried using atacontrol... > > > > With this: > > On Fre

Re: huge_page_size parameter description in the pg 14 docs is not exact

2022-07-20 Thread Thomas Munro
On Thu, Jul 21, 2022 at 2:03 AM Bruce Momjian wrote: > On Wed, Jul 20, 2022 at 09:56:37PM +0800, yanliang lei wrote: > > https://www.postgresql.org/docs/15/runtime-config-resource.html# > > GUC-HUGE-PAGE-SIZE > > > > the following is from the above website: > > > > Some commonly available page siz

Re: The huge_pages parameter doesn't work when shared_memory_type is sysv

2021-10-25 Thread Thomas Munro
On Sat, Oct 23, 2021 at 9:20 AM Alexander Lakhin wrote: > Thanks for the fix! It works and looks correct to me. Pushed. Thanks.

Re: The huge_pages parameter doesn't work when shared_memory_type is sysv

2021-10-21 Thread Thomas Munro
r message too (the idea was to reject that combination on Linux but allow it on AIX). Here are those bits, extracted. https://www.postgresql.org/message-id/flat/HE1PR0202MB28126DB4E0B6621CC6A1A91286D90%40HE1PR0202MB2812.eurprd02.prod.outlook.com From c27b1eae1a528f04ab09f60de80ccfa8fbaa7534 Mon Sep 17 00:00

Re: Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

2021-10-05 Thread Thomas Munro
On Wed, Oct 6, 2021 at 3:48 AM Tom Lane wrote: > PG Doc comments form writes: > > On https://www.postgresql.org/docs/12/kernel-resources.html, the command to > > calculate memory allocated to postgres is not correct. Following is the > > command as shown in 18.4.5. Linux Huge Pages. > > pmap 4170

Re: Second-granular timezone offset format not documented

2021-07-07 Thread Thomas Munro
On Tue, Jul 6, 2021 at 2:04 AM Tom Lane wrote: > I tried to interest them in dropping the LMT idea altogether [1]. FWIW, I agree with you. It's meaningless because those coordinates don't seem to be the meridians historically used for local mean time (Trafalgar Square may be the prime meridian f

Re: Second-granular timezone offset format not documented

2021-07-04 Thread Thomas Munro
On Mon, Jul 5, 2021 at 9:56 AM PG Doc comments form wrote: > Note how the response has a very weird timezone offset. I guess it is valid, As for whether it's valid, that's coming from the IANA tz dataset. It has a moment that it believes standard time to have begun at each location, in this case

Re: [DOC] pg_stat_replication_slots representation style inconsisitant

2021-05-11 Thread Thomas Munro
On Wed, May 12, 2021 at 12:49 AM tanghy.f...@fujitsu.com wrote: > On Tuesday, May 11, 2021 2:42 PM, Michael Paquier wrote: > >I was looking at this thread, and please note that there is no need to > >do anything here as the WAL prefetch has been reverted for now as of > >c2dc1934. > > Thanks for

Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?

2020-11-01 Thread Thomas Munro
On Fri, Oct 30, 2020 at 11:24 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/runtime-config-resource.html > Description: > > https://www.postgresql.org/docs/13/runtime-config-resource.html#RUNTIME-CO

Re: initdb - creating clusters

2020-08-29 Thread Thomas Munro
On Wed, Aug 26, 2020 at 12:05 AM Daniel Gustafsson wrote: > I took the liberty of adding the proposed patch upthread to the next > commitfest > to make sure it's not forgotten about, as I do think it will improve the docs. + The discussions in this chapter assume that you are working with + an

Re: "innovative Serializable Snapshot Isolation (SSI) level"

2020-08-03 Thread Thomas Munro
On Tue, Aug 4, 2020 at 10:24 AM Bruce Momjian wrote: > On Mon, Aug 3, 2020 at 01:41:24AM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/12/mvcc-intro.html > > Description: > > > > The documen

Re: Change JOIN tutorial to focus more on explicit joins

2020-07-17 Thread Thomas Munro
On Wed, May 27, 2020 at 8:29 PM Jürgen Purtz wrote: > > The "new" syntax is 28 years old, from SQL 92. I don't see too many > > SQL 86 joins. Would you like to write a documentation patch? > > > > > The attached patch > > - prefers the explicit join-syntax over the implicit one and explains > th

Re: Documentation Issue?

2020-07-15 Thread Thomas Munro
On Wed, Jul 15, 2020 at 5:25 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/tutorial-join.html > Description: > > The documentation at https://www.postgresql.org/docs/12/tutorial-join.html > shows th

Re: wal_init_zero and wal_recycle

2020-05-27 Thread Thomas Munro
On Wed, May 27, 2020 at 7:09 PM Simon Riggs wrote: > On Wed, 27 May 2020 at 04:27, Fujii Masao wrote: >> >> Hi, >> >> The group of wal_init_zero and wal_recycle is WAL_SETTINGS in guc.c, >> but their descriptions are located in "19.6. Replication"/"19.6.1. Sending >> Servers" section. This seems

Re: Change JOIN tutorial to focus more on explicit joins

2020-05-20 Thread Thomas Munro
On Thu, May 21, 2020 at 1:37 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/tutorial-join.html > Description: > > The tutorial about joins makes the following statement about the explicit > JOIN oper

Re: Serializable description seems misleading?

2019-12-10 Thread Thomas Munro
On Wed, Dec 11, 2019 at 11:27 AM PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/12/transaction-iso.html > Description: > > Let's say I have two transactions running in Serializable isolation: > T1: Reads a row > T2: Reads the same row > T1: Updates the row > T1: Commits > T2:

Re: Character classes

2019-05-21 Thread Thomas Munro
0P seems to be for POSIX headers, or something like that. BSDen don't seem to bother with this distinction and just provide ctype(3). -- Thomas Munro https://enterprisedb.com

Re: Update section on NFS

2019-04-26 Thread Thomas Munro
c" violated the spec, which might explain that. Only HP-UX's version of share_nfs (which says it came from Sun) seems to have sprouted (or not lost?) an "async" option. I didn't look into the client side of that, though "hard" and "soft" are understood everywhere I looked. -- Thomas Munro https://enterprisedb.com

Re: Tutorial section of documentation: enhancements needed

2019-02-17 Thread Thomas Munro
Ubuntu on WSL). Then they could use the same super short how-to-get-start guides as everyone else (I think the guide for setting up native Windows development tools would be considerably longer, since AFAIK you can't yet do something as easy as "apt-get foo bar baz" and start hacking, but I don't know). -- Thomas Munro http://www.enterprisedb.com

Re: Typo in description of replay_lag attribute in pg_stat_replication view

2018-12-03 Thread Thomas Munro
this was discussed but somehow went off-course and never made it to the finish line: https://www.postgresql.org/message-id/flat/CAEepm%3D3FFaanSS4sugG%2BApzq2tCVjEYCO2wOQBod2d7GWb%3DDvA%40mail.gmail.com -- Thomas Munro http://www.enterprisedb.com

Re: bloom documentation patch

2018-10-14 Thread Thomas Munro
is rounded up to the nearest + multiple of 16. The default is 80 bits and maximum is s/, it is/. It is/ s/and maximum/and the maximum/ + Bloom AM doesn't supports unique indexes. s/supports/support/ + Bloom AM doesn't supports NULL values. s/supports/support/ --

Re: typo in parallel safety doc

2018-08-16 Thread Thomas Munro
On Fri, Aug 17, 2018 at 1:12 PM, Justin Pryzby wrote: > On Fri, Aug 17, 2018 at 11:39:27AM +1200, Thomas Munro wrote: >> On Fri, Aug 17, 2018 at 7:54 AM, Justin Pryzby wrote: >> > https://www.postgresql.org/docs/10/static/parallel-safety.html >> > |Even for simple fun

Re: typo in parallel safety doc

2018-08-16 Thread Thomas Munro
ULD conceivably" Right, thanks. Will fix. -- Thomas Munro http://www.enterprisedb.com

Re: MacPorts xsltproc is very slow?

2018-04-26 Thread Thomas Munro
On Sat, Mar 3, 2018 at 3:53 PM, Thomas Munro wrote: > On Sat, Mar 3, 2018 at 9:34 AM, Thomas Munro > wrote: >> I think we should complain to the MacPorts packager about the >> namespace vs non-namespace stuff being possibly confused in the >> packages. > > https://

Re: MacPorts xsltproc is very slow?

2018-03-22 Thread Thomas Munro
On Fri, Mar 23, 2018 at 3:27 AM, Robert Haas wrote: > On Fri, Mar 2, 2018 at 3:34 PM, Thomas Munro > wrote: >> I think we should complain to the MacPorts packager about the >> namespace vs non-namespace stuff being possibly confused in the >> packages. > > Any id

Re: MacPorts xsltproc is very slow?

2018-03-02 Thread Thomas Munro
On Sat, Mar 3, 2018 at 9:34 AM, Thomas Munro wrote: > I think we should complain to the MacPorts packager about the > namespace vs non-namespace stuff being possibly confused in the > packages. https://trac.macports.org/ticket/55946 -- Thomas Munro http://www.enterprisedb.com

Re: MacPorts xsltproc is very slow?

2018-03-02 Thread Thomas Munro
On Sat, Mar 3, 2018 at 8:51 AM, Robert Haas wrote: > On Sun, Nov 26, 2017 at 5:03 PM, Thomas Munro > wrote: >> So one solution is simply to uninstall the docbook-xsl package. That >> gets me back to fast documentation builds! > > For me, the documentation build fails

Re: Trigger behaviour not as stated

2018-01-28 Thread Thomas Munro
gt; > Fix transition tables for partition/inheritance. > > We disallow row-level triggers with transition tables on child > tables. > Transition tables for triggers on the parent table contain only > those > columns present in t

Element sup in namespace '' encountered in a, but no template matches.

2018-01-04 Thread Thomas Munro
but no template matches. Note: Writing man7/CREATE_POLICY.7 -- Thomas Munro http://www.enterprisedb.com

Re: MacPorts xsltproc is very slow?

2017-11-26 Thread Thomas Munro
On Sun, Nov 26, 2017 at 4:21 AM, Tom Lane wrote: > Thomas Munro writes: >> ... I couldn't help noticing that >> templates with match="chapter" and match="appendix" appear in our tree >> in sgml/stylesheet-speedup-common.xsl with a comment >&

Re: MacPorts xsltproc is very slow?

2017-11-25 Thread Thomas Munro
27;re falling back to non-optimised versions instead of these? > I wonder, what version of docbook-xsl are you using? > (I have 1.79.1+dfsg-1). > Can you check with 1.79+ (if yours is older)? docbook-xsl version 1.79.2_1. -- Thomas Munro http://www.enterprisedb.com

Re: MacPorts xsltproc is very slow?

2017-11-24 Thread Thomas Munro
On Sat, Nov 25, 2017 at 4:57 PM, Alexander Lakhin wrote: > Can you show the output of > make XSLTPROCFLAGS="--profile" -C doc/src/sgml/html > or > make XSLTPROCFLAGS="--profile" docs > ? Hi Alexander, please see attached. -- Thomas Munro http://www.enterp

MacPorts xsltproc is very slow?

2017-11-24 Thread Thomas Munro
ly received. [1] https://www.postgresql.org/message-id/bfce8c4e-e200-9617-791a-4e05a054e698%40gmail.com -- Thomas Munro http://www.enterprisedb.com