public inbox for [email protected]help / color / mirror / Atom feed
Re: Fix output of zero privileges in psql 2+ messages / 2 participants [nested] [flat]
* Re: Fix output of zero privileges in psql @ 2023-10-17 16:33 Tom Lane <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2023-10-17 16:33 UTC (permalink / raw) To: Laurenz Albe <[email protected]>; +Cc: David G. Johnston <[email protected]>; Erik Wienhold <[email protected]>; PostgreSQL Hackers <[email protected]> Laurenz Albe <[email protected]> writes: > On Mon, 2023-10-16 at 19:05 -0700, David G. Johnston wrote: >> Reading both threads I'm not seeing any specific rejection of the >> solution that we simply represent empty privileges as "(none)". > Thanks for that summary. I prefer my version (simply display NULLs > as NULLs), but I am not wedded to it. I had the impression that Tom > would prefer that too, but is woried if the incompatibility introduced > would outweigh the small benefit (of either patch). > So it is clear that we don't have a consensus. FWIW, my druthers are to make the describe.c queries honor \pset null (not only for privileges, but anywhere else they fail to) and do nothing beyond that. I think that'll generally reduce the surprise factor, while anything else we might opt to do will increase it. If that fails to garner a consensus, my second choice would be to do that plus translate empty-but-not-null ACLs to "(none)". regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
* [PATCH v1 1/1] Add list of major features to the v19 release notes. @ 2026-07-01 21:33 Nathan Bossart <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Nathan Bossart @ 2026-07-01 21:33 UTC (permalink / raw) --- doc/src/sgml/release-19.sgml | 79 +++++++++++++++++++++++++++++++++++- 1 file changed, 78 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml index d8d3758d5ba..00c620b283c 100644 --- a/doc/src/sgml/release-19.sgml +++ b/doc/src/sgml/release-19.sgml @@ -19,7 +19,84 @@ <itemizedlist> <listitem> - <para><emphasis>fill in later</emphasis></para> + <para> + Support for + <link linkend="ddl-property-graphs">property graph queries</link> + (<acronym>SQL/PGQ</acronym>). + </para> + </listitem> + + <listitem> + <para> + A new <link linkend="sql-repack"><command>REPACK</command></link> command + that reclaims disk space and reorganizes table contents, combining the + functionality of the existing <command>VACUUM FULL</command> and + <command>CLUSTER</command> commands. Its <literal>CONCURRENTLY</literal> + option allows repacking without blocking reads and writes to the table. + </para> + </listitem> + + <listitem> + <para> + Logical replication now + <link linkend="logical-replication-sequences">replicates sequence values</link>, + and it can be enabled without a server restart when + <xref linkend="guc-wal-level"/> is set to <literal>replica</literal>. + </para> + </listitem> + + <listitem> + <para> + Autovacuum can now use + <link linkend="guc-autovacuum-max-parallel-workers">multiple worker processes</link> + to vacuum a single table in parallel, and a + <link linkend="autovacuum-priority">new scoring system</link> prioritizes + the tables that most need vacuuming or analyzing. + </para> + </listitem> + + <listitem> + <para> + Faster performance in many areas, including automatic scaling of the + number of <link linkend="guc-io-max-workers">I/O worker processes</link>, + quicker foreign-key checks, and further planning and execution + optimizations. + </para> + </listitem> + + <listitem> + <para> + Data checksums can now be + <link linkend="checksums-online-enable-disable">enabled or disabled while the database is running</link>. + </para> + </listitem> + + <listitem> + <para> + A new <link linkend="sql-wait-for"><command>WAIT FOR</command></link> + command that lets an application pause until a standby has replayed + changes up to a chosen point, thereby supporting + <quote>read-your-writes</quote> query patterns on standbys. + </para> + </listitem> + + <listitem> + <para> + <xref linkend="sql-update"/> and <xref linkend="sql-delete"/> can now + change or remove data for just part of a time range via the new + <literal>FOR PORTION OF</literal> clause. + </para> + </listitem> + + <listitem> + <para> + A new + <link linkend="pgplanadvice"><application>pg_plan_advice</application></link> + extension for stabilizing and controlling the query planner's decisions, + together with the companion + <link linkend="pgstashadvice"><application>pg_stash_advice</application></link> + extension that applies this advice automatically based on the query. + </para> </listitem> </itemizedlist> -- 2.50.1 (Apple Git-155) --Dy4bd/k8yrlB0eLC-- ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-07-01 21:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-10-17 16:33 Re: Fix output of zero privileges in psql Tom Lane <[email protected]> 2026-07-01 21:33 [PATCH v1 1/1] Add list of major features to the v19 release notes. Nathan Bossart <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox