I wrote a summary of lesser-known Postgres type system information

2024-04-20 Thread Guyren Howe
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/

Re: Logging statement having any threat?

2024-04-20 Thread Adrian Klaver
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

Re: Logging statement having any threat?

2024-04-20 Thread Adrian Klaver
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

Logging statement having any threat?

2024-04-20 Thread Lok P
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

Re: Performance degradation after upgrading from 9.5 to 14

2024-04-20 Thread kaido vaikla
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