I'm not sure, does it helps you but read this:
https://www.cybertec-postgresql.com/en/b-tree-index-improvements-in-postgresql-v12/
"Since upgrading with pg_upgrade does not change the data files, indexes
will still be in version 3 after an upgrade"
I reindexed all my database, when did upgrade pg<
Hello All,
Its postgres version 15.4 and its RDS, in which our dev team gets the
infrastructure code from another third party team which provides us base
infrastructure code to build a postgres database, in which we will be able
to do change DB parameter values etc whatever is mentioned in the file
On 4/20/24 07:02, Lok P wrote:
Hello All,
Its postgres version 15.4 and its RDS, in which our dev team gets the
infrastructure code from another third party team which provides us base
infrastructure code to build a postgres database, in which we will be
able to do change DB parameter values e
On 4/20/24 07:02, Lok P wrote:
Now when we reach out to the infrastructure team , they are saying these
variables(pg_cluster_log_statement,pg_instance_log_statement) were
removed due to potential security threat. So I want to understand from
experts here , how this is really a security threat
At PostgresConf 2024, I gave a presentation about PostgreSQL types (thanks to
folks on this list for the assist with that).
I wrote up a summary of it here:
https://lydb.xyz/postgres-types/