2022年1月20日(木) 3:24 Wells Oliver <wells.oliver@gmail.com>:
>
> Understood: wanted to double check that an outright empty value would be understood by the server as 0, or otherwise.
In standard PostgreSQL, if the configuration for an integer parameter
is empty or an
empty string, an error will be raised:
postgres=# ALTER SYSTEM SET effective_io_concurrency = '';
ERROR: invalid value for parameter "effective_io_concurrency": ""
RDS is not standard PostgreSQL though, so something else might be
going on there.
Does:
SELECT * FROM pg_settings WHERE name = 'effective_io_concurrency'
show anything?
Regards
Ian Barwick
> On Wed, Jan 19, 2022 at 9:46 AM Ron <ronljohnsonjr@gmail.com> wrote:
>>
>> On 1/19/22 11:40 AM, Wells Oliver wrote:
>>
>> Hi all-- I notice in the default PG 13 settings for Postgres on RDS, effective_io_concurrency is empty, and doing a
"showeffective_io_concurrency" also shows an empty value-- what's the effect of this? That PG assumes 0 for the
setting?
>>
>>
>> https://www.postgresql.org/docs/13/runtime-config-resource.html
>>
>> "The allowed range is 1 to 1000, or zero to disable issuance of asynchronous I/O requests. Currently, this setting
onlyaffects bitmap heap scans."
>>
>> --
>> Wells Oliver
>> wells.oliver@gmail.com
>>
>>
>> --
>> Angular momentum makes the world go 'round.
>
>
>
> --
> Wells Oliver
> wells.oliver@gmail.com
--
EnterpriseDB: https://www.enterprisedb.com