Horton

Re: doc: create table improvements

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-04-24T14:45:47Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Doc: declutter CREATE TABLE synopsis.

  2. Remove support for unlogged on partitioned tables

On Wed, Apr 24, 2024 at 3:30 AM Peter Eisentraut <peter@eisentraut.org>
wrote:

>  > +   The reliability characteristics of a table are governed by its
>  > +   persistence mode.  The default mode is described
>  > +   <link linkend="wal-reliability">here</link>
>  > +   There are two alternative modes that can be specified during
>  > +   table creation:
>  > +   <link linkend="sql-createtable-temporary">temporary</link> and
>  > +   <link linkend="sql-createtable-unlogged">unlogged</link>.
>
> Not sure reliability is the best word here.  I mean, a temporary table
> isn't any less reliable than any other table.  It just does different
> things.
>
>
Given the name of the section where this is all discussed I'm having
trouble going with a different word.  But better framing and phrasing I can
do:

A table may be opted out of certain storage aspects of reliability, as
described [here], by specifying either of the alternate persistence modes:
[temporary] or [logged]. The specific trade-offs and implications are
detailed below.

David J.