pgsql: Allow passing extra options to initdb for tests

Allow passing extra options to initdb for tests Setting the environment variable PG_TEST_INITDB_EXTRA_OPTS passes extra options to initdb run by pg_regress or PostgreSQL::Test::Cluster's init. This can be useful for a wide variety of uses, like running all tests with checksums enabled, or with JI

pgsql: Pull up ANY-SUBLINK with the necessary lateral support.

Pull up ANY-SUBLINK with the necessary lateral support. For ANY-SUBLINK, we adopted a two-stage pull-up approach to handle different types of scenarios. In the first stage, the sublink is pulled up as a subquery. Because of this, when writing this code, we did not have the ability to perform later

Re: pgsql: Allow upgrades to preserve the full subscription's state.

On 02.01.24 04:07, Amit Kapila wrote: Allow upgrades to preserve the full subscription's state. The added test src/bin/pg_upgrade/t/004_subscription.pl does not pass when export PG_TEST_PG_UPGRADE_MODE=--link is set. Could you check whether that could be fixed, or otherwise if the test need

pgsql: Doc: improve a couple of comments in postgresql.conf.sample.

Doc: improve a couple of comments in postgresql.conf.sample. Clarify comments associated with max_parallel_workers and related settings. Per bug #18343 from Christopher Kline. Discussion: https://postgr.es/m/[email protected] Branch -- REL_12_STABLE Details --- http

pgsql: Doc: improve a couple of comments in postgresql.conf.sample.

Doc: improve a couple of comments in postgresql.conf.sample. Clarify comments associated with max_parallel_workers and related settings. Per bug #18343 from Christopher Kline. Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git

pgsql: Doc: improve a couple of comments in postgresql.conf.sample.

Doc: improve a couple of comments in postgresql.conf.sample. Clarify comments associated with max_parallel_workers and related settings. Per bug #18343 from Christopher Kline. Discussion: https://postgr.es/m/[email protected] Branch -- REL_13_STABLE Details --- http

pgsql: Doc: improve a couple of comments in postgresql.conf.sample.

Doc: improve a couple of comments in postgresql.conf.sample. Clarify comments associated with max_parallel_workers and related settings. Per bug #18343 from Christopher Kline. Discussion: https://postgr.es/m/[email protected] Branch -- REL_14_STABLE Details --- http

pgsql: Doc: improve a couple of comments in postgresql.conf.sample.

Doc: improve a couple of comments in postgresql.conf.sample. Clarify comments associated with max_parallel_workers and related settings. Per bug #18343 from Christopher Kline. Discussion: https://postgr.es/m/[email protected] Branch -- REL_16_STABLE Details --- http

pgsql: Doc: improve a couple of comments in postgresql.conf.sample.

Doc: improve a couple of comments in postgresql.conf.sample. Clarify comments associated with max_parallel_workers and related settings. Per bug #18343 from Christopher Kline. Discussion: https://postgr.es/m/[email protected] Branch -- REL_15_STABLE Details --- http

pgsql: Introduce transaction_timeout

Introduce transaction_timeout This commit adds timeout that is expected to be used as a prevention of long-running queries. Any session within the transaction will be terminated after spanning longer than this timeout. However, this timeout is not applied to prepared transactions. Only transactio

pgsql: Followup fixes for transaction_timeout

Followup fixes for transaction_timeout Don't deal with transaction timeout in PostgresMain(). Instead, release transaction timeout activated by StartTransaction() in CommitTransaction()/AbortTransaction()/PrepareTransaction(). Deal with both enabling and disabling transaction timeout in assign_t

pgsql: Attempt to stabilize flapping regression test

Attempt to stabilize flapping regression test Per buildfarm animal mylodon, the plan for this test was sometimes swapping the join order for tenk1 and tenk2. Given that add_path() has no code that would cause this fluctuation when given paths with consistent costs, this indicates that the costs m

Re: pgsql: Allow upgrades to preserve the full subscription's state.

On Thu, Feb 15, 2024 at 7:15 PM Peter Eisentraut wrote: > > On 02.01.24 04:07, Amit Kapila wrote: > > Allow upgrades to preserve the full subscription's state. > > The added test src/bin/pg_upgrade/t/004_subscription.pl does not pass when > > export PG_TEST_PG_UPGRADE_MODE=--link > > is set. > > C

pgsql: Add more LOG and DEBUG messages for slot synchronization.

Add more LOG and DEBUG messages for slot synchronization. This provides more information about remote slots during synchronization which helps in debugging bugs and BF failures due to test case issues. We might later want to change the LOG message added by this patch to DEBUG1. Author: Hou Zhijie

pgsql: Change the LOG level in 040_standby_failover_slots_sync.pl to DE

Change the LOG level in 040_standby_failover_slots_sync.pl to DEBUG2. Temporarily change the log level of 040_standby_failover_slots_sync.pl to DEBUG2. This is to get more information about BF failures. We will reset it back to default once the tests are stabilized. Author: Hou Zhijie Reviewed-by

pgsql: Fix the incorrect format specifier used in commit 7a424ece48.

Fix the incorrect format specifier used in commit 7a424ece48. Author: Hou Zhijie Discussion: https://postgr.es/m/[email protected] Discussion: https://postgr.es/m/os0pr01mb5716cb015bad807b29bc55be94...@os0pr01mb5716.jpnprd01.prod.outlook.com Branch -- mas