MIME-Version: 1.0
References: 
 <CADkLM=fwtE-TCU7sRnvaE74z12kOp_A+CdUwMr7aZt39pXbh6A@mail.gmail.com>
 <20200320001122.GA19602@alvherre.pgsql>
 <20200320195841.GA13662@telsasoft.com>
In-Reply-To: <20200320195841.GA13662@telsasoft.com>
From: Robert Haas <robertmhaas@gmail.com>
Date: Tue, 24 Mar 2020 14:46:39 -0400
Message-ID: 
 <CA+TgmoYT2NnUueP5_=Z48XwVpyzciBfNxuuvYKUtLh-korZEmg@mail.gmail.com>
Subject: Re: Add A Glossary
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>,
 Corey Huinker <corey.huinker@gmail.com>,
	=?UTF-8?Q?J=C3=BCrgen_Purtz?= <juergen@purtz.de>,
	Roger Harkavy <rogerharkavy@gmail.com>,
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>,
 Fabien COELHO <coelho@cri.ensmp.fr>,
	Michael Paquier <michael@paquier.xyz>
Content-Type: text/plain; charset="UTF-8"
Precedence: bulk

On Fri, Mar 20, 2020 at 3:58 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> > +      A process that writes dirty pages and <glossterm>WAL
> > +      Records</glossterm> 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.)

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company