public inbox for [email protected]  
help / color / mirror / Atom feed
From: Justin Pryzby <[email protected]>
To: Pavel Stehule <[email protected]>
Cc: Julien Rouhaud <[email protected]>
Cc: Erik Rijkers <[email protected]>
Cc: Dean Rasheed <[email protected]>
Cc: Joel Jacobson <[email protected]>
Cc: [email protected]
Subject: Re: Schema variables - new implementation for Postgres 15
Date: Mon, 22 Aug 2022 09:05:43 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFj8pRARLwdB6+-_uG49jAg52_VW-wY_f5hiModS0au8bjH3sw@mail.gmail.com>
References: <CAFj8pRDEju80i-xm1fNE54yiBB-QJ1ee8b15Ka4R-uWeZ3vdhg@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<CAFj8pRDdvgLqqOqeVWHG-YR2D208s5iGK9ZHvxvudh906aa+ug@mail.gmail.com>
	<[email protected]>
	<20220820143505.keuvmu4n2lwdibk2@jrouhaud>
	<CAFj8pRAMW0Tjt4jiVJVGQC4OsQM78M=1Jr49OMtW9DHEvzcH2w@mail.gmail.com>
	<[email protected]>
	<20220821043621.jiyfjns5k2sue6xe@jrouhaud>
	<CAFj8pRARLwdB6+-_uG49jAg52_VW-wY_f5hiModS0au8bjH3sw@mail.gmail.com>

> +-- test on query with workers
> +CREATE TABLE svar_test(a int);
> +INSERT INTO svar_test SELECT * FROM generate_series(1,1000000);

When I looked at this, I noticed this huge table.

I don't think you should create such a large table just for this.

To exercise parallel workers with a smaller table, decrease
min_parallel_table_scan_size and others as done in other regression tests.

-- 
Justin





view thread (188+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Schema variables - new implementation for Postgres 15
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox