Re: PostgreSQL 16 release announcement draft

Op 8/26/23 om 04:51 schreef Jonathan S. Katz: On 8/24/23 11:17 AM, Erik Rijkers wrote: Op 8/24/23 om 16:32 schreef Jonathan S. Katz: On 8/23/23 5:07 PM, David Rowley wrote: On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz wrote: Hi, When v15 docs have: "27.2.7. Cascading Replication The cas

Re: PostgreSQL 16 release announcement draft

On 8/24/23 11:19 AM, Alvaro Herrera wrote: On 2023-Aug-24, Jonathan S. Katz wrote: ### Performance Improvements PostgreSQL 16 improves the performance of existing PostgreSQL functionality through new query planner optimizations. In this latest release, the query planner can parallelize `FULL`

Re: PostgreSQL 16 release announcement draft

On 8/24/23 11:17 AM, Erik Rijkers wrote: Op 8/24/23 om 16:32 schreef Jonathan S. Katz: On 8/23/23 5:07 PM, David Rowley wrote: On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz wrote: Hi, When v15 docs have: "27.2.7. Cascading Replication The cascading replication feature allows a standby ser

Re: PostgreSQL 16 release announcement draft

On 8/24/23 12:54 PM, Dave Cramer wrote: > Postgres, PostgreSQL, and the Elephant Logo (Slonik) are all registered > trademarks of the [PostgreSQL Community Association of Canada](https://www.postgres.ca ). Isn't this just the "PostgreSQL Communit

Re: PostgreSQL 16 release announcement draft

> > > > Postgres, PostgreSQL, and the Elephant Logo (Slonik) are all registered > > trademarks of the [PostgreSQL Community Association of Canada]( > https://www.postgres.ca). > > Isn't this just the "PostgreSQL Community Association", no Canada? > Certainly confusing from the website, but in the

Re: PostgreSQL 16 release announcement draft

On 2023-08-24 11:23, Jonathan S. Katz wrote: SELECT $1::int + $2::int \bind 1 2 \g One cast also works, letting type inference figure out the other. So if I say SELECT $1::int + $2 \gdesc it tells me the result will be int. That made me wonder if there is a \gdesc variant to issue the "state

Re: PostgreSQL 16 release announcement draft

On 8/24/23 11:16 AM, jian he wrote: hi. Can you check my first email about "a" versus "the" and "pg_stat_activity". I did when you first sent it, and did not make any changes. also: "including the `\bind` command, which allows users to execute parameterized queries (e.g `SELECT $1 + $2`) then

Re: PostgreSQL 16 release announcement draft

On 2023-Aug-24, Jonathan S. Katz wrote: > ### Performance Improvements > > PostgreSQL 16 improves the performance of existing PostgreSQL functionality > through new query planner optimizations. In this latest release, the query > planner can parallelize `FULL` and `RIGHT` joins, generate better

Re: PostgreSQL 16 release announcement draft

hi. Can you check my first email about "a" versus "the" and "pg_stat_activity". also: "including the `\bind` command, which allows users to execute parameterized queries (e.g `SELECT $1 + $2`) then use `\bind` to substitute the variables." The example actually is very hard to reproduce. (it's not

Re: PostgreSQL 16 release announcement draft

Op 8/24/23 om 16:32 schreef Jonathan S. Katz: On 8/23/23 5:07 PM, David Rowley wrote: On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz wrote: Hi, When v15 docs have: "27.2.7. Cascading Replication The cascading replication feature allows a standby server to accept replication connections and

Re: PostgreSQL 16 release announcement draft

On 8/23/23 5:07 PM, David Rowley wrote: On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz wrote: We could add something about 1349d2790 -- do you have suggested wording? I think it's worth a mention. See the text added in square brackets below: PostgreSQL 16 improves the performance of existing

Re: PostgreSQL 16 release announcement draft

On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz wrote: > We could add something about 1349d2790 -- do you have suggested wording? I think it's worth a mention. See the text added in square brackets below: PostgreSQL 16 improves the performance of existing PostgreSQL functionality through new quer

Re: PostgreSQL 16 release announcement draft

On 8/23/23 8:02 AM, David Rowley wrote: On Wed, 23 Aug 2023 at 22:21, jian he wrote: PostgreSQL 16 improves the performance of existing PostgreSQL functionality through new query planner optimizations. In this latest release, the query planner can parallelize `FULL` and `RIGHT` joins, util

Re: PostgreSQL 16 release announcement draft

On Wed, 23 Aug 2023 at 22:21, jian he wrote: > > >>> > PostgreSQL 16 improves the performance of existing PostgreSQL functionality > through new query planner optimizations. In this latest release, the query > planner can parallelize `FULL` and `RIGHT` joins, utilize incremental sorts > for > `S

Re: PostgreSQL 16 release announcement draft

>>> PostgreSQL 16 improves the performance of existing PostgreSQL functionality through new query planner optimizations. In this latest release, the query planner can parallelize `FULL` and `RIGHT` joins, utilize incremental sorts for `SELECT DISTINCT` queries, and execute window functions more ef

Re: PostgreSQL 16 release announcement draft

> Additionally, this release adds a new field to the pg_stat_all_tables view, capturing a timestamp representing when a table or index was last scanned. PostgreSQL also makes auto_explain more readable by logging values passed into parameterized statements, and improves accuracy of pg_stat_acti