Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jGpD8-0006Qq-2k for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2020 19:27:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jGpD6-0004l0-SD for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2020 19:27:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jGpD6-0004ks-JG for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2020 19:27:36 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jGpD4-0007ZP-EW for pgsql-hackers@postgresql.org; Tue, 24 Mar 2020 19:27:36 +0000 Received: by mail-ed1-x52a.google.com with SMTP id a43so22107998edf.6 for ; Tue, 24 Mar 2020 12:27:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=qMJ3OJO21WEKwHPoehLJO5APqzRP957Sm21uP5fWwmE=; b=R8lgiWdwjw37i2cT7X6lz/kytPC+5fOm1x5mvLZl6JHqugVjRvtPPt84z/r1Do3DLb cH2EOncUy5A4Z8IcCyS7zEauWLjMwEpcl9Ks/da2g8oNM7IM19Lbw26MTHjoii64s936 15DZ/EWR5NH+f4UF7iCR2ohNaLpD1y5uBYN7j3u9oAm37isutYyq+g6CIN91IfkxNd2x 4b7F2HqkV11WAkkR5COYc4OXtCTxRjdQV6LzsQcjhWs0J/RkHLjQO3+luZLg6c2Ywcma 8iEK050vltLCfkIo+niiORfwlNpQ0JNTVE5o9uDGQiWrlLbkOkzywq+9nwCgBieXmkF1 Zw8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=qMJ3OJO21WEKwHPoehLJO5APqzRP957Sm21uP5fWwmE=; b=VDbnaAA9nQ04lFL4Rc7CAqQo4uka6z8pnEKfvcCUKJmik3J8a8XCdXroRsQr56lQs0 Iz2TwSXdrKg9nNnVoSx8rHUZDfo08DbESAzj+9WWX6guQkgVRdyHNpt3zAu/2dOsXaXb j3hqhB1ybR/tJR29ETpIVfKW4yjc0cDo3YfimYNge5QebxL8wh2onKRq1kjhZRJuZrnB 5rjOfAArIP9JPdmhlubdpSnGNqFZjRryUXDJKyxMYffE9qx9weZUzsjBUlzg9+v4j5vN 3HvfBdvvMvU2V77cUNqnRdMEhsbZE5MRZlBg1ed1djwOUTplzA9T3SKr3+6ztAUUP/pu J/HA== X-Gm-Message-State: ANhLgQ0qSfqbPdtQ1qnMwpFKcTFpZTWs5u29jAzhfPIt/D25hBkTDYwy fhyvoRtnqVCwT7AR24WzlFKr1UDzzK3Dg7XXIOY= X-Google-Smtp-Source: ADFU+vuXPgmz0aMqi3U2sGc5cEsLhxbDeRsogzdDduM4JoicNDz4+g2HgHid0hH+d8xN8x+Q+Z+04iNKdn9YhTVtCqM= X-Received: by 2002:a17:906:5e13:: with SMTP id n19mr24730783eju.236.1585078052862; Tue, 24 Mar 2020 12:27:32 -0700 (PDT) MIME-Version: 1.0 References: <20200320001122.GA19602@alvherre.pgsql> <20200320195841.GA13662@telsasoft.com> In-Reply-To: From: Corey Huinker Date: Tue, 24 Mar 2020 15:27:21 -0400 Message-ID: Subject: Re: Add A Glossary To: Robert Haas Cc: Justin Pryzby , Alvaro Herrera , =?UTF-8?Q?J=C3=BCrgen_Purtz?= , Roger Harkavy , "pgsql-hackers@postgresql.org" , Fabien COELHO , Michael Paquier Content-Type: multipart/alternative; boundary="000000000000483d9205a19ebe0d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000483d9205a19ebe0d Content-Type: text/plain; charset="UTF-8" > > > > > + Records to the file system and creates a special > > > > Does the chckpointer actually write WAL ? > > Yes. > > > An FK doesn't require the values in its table to be unique, right ? > > I believe it does require that the values are unique. > > > I think there's some confusion. Constraints are not objects, right ? > > I think constraints are definitely objects. They have names and you > can, for example, COMMENT on them. > > > Do we use shared_buffers for WAL ? > > No. > > (I have not reviewed the patch; these are just a few comments on your > comments.) > > I'm going to be coalescing the feedback into an updated patch very soon (tonight/tomorrow), so please keep the feedback on the text/wording coming until then. If anyone has a first attempt at all the ACID definitions, I'd love to see those as well. --000000000000483d9205a19ebe0d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

> > +=C2=A0 =C2=A0 =C2=A0 Records</glosster= m> to the file system and creates a special
>
> Does the chckpointer actually write WAL ?

Yes.

> An FK doesn't require the values in its table to be unique, right = ?

I believe it does require that the values are unique.

> I think there's some confusion.=C2=A0 Constraints are not objects,= right ?

I think constraints are definitely objects. They have names and you
can, for example, COMMENT on them.

> Do we use shared_buffers for WAL ?

No.

(I have not reviewed the patch; these are just a few comments on your comme= nts.)


I'm going to be coalescin= g the feedback into an updated patch very soon (tonight/tomorrow), so pleas= e keep the feedback on the text/wording coming until then.
If any= one has a first attempt at all the ACID definitions, I'd love to see th= ose as well.

=C2=A0
--000000000000483d9205a19ebe0d--