Question : I am currently trying to create a table with a text column which will compare case insensitive by […]
Tag: postgresql-12
Function in same Session become increasingly slow when run multiple times concurrently
Question : PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit Client is Data Grip and […]
Postgres pg_wals full whats best practice for removal of old WALs that were not removed automatically
Question : We had an outage on our postgresql-12 server at the weekend, we have pg_wals that reside on a […]
PLPGSQL: Cannot use parameters inside a function query
Question : I’m trying to create a function that returns all events with the corresponding week number, and the day […]
Function in same Session become increasingly slow when run multiple times concurrently
Question : PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit Client is Data Grip and […]
Query slow when using function in the WHERE clause
Question : This is fast (49ms): v_cpf_numerico := ext.uf_converte_numerico(new.nr_cpf); select cd_cliente into v_cd_cliente from central.cliente where nr_cpf_cnpj = v_cpf_numerico; This […]
Sort varchar by its numeric fields
Question : I’m sure this has been asked before, but since the question can be formulated in many different ways […]
Combining table under different alias
Question : I have two tables trips and users. Whenever an user posts a trip, it stores id of the […]
When to run Vacuum Full
Question : Reading the PostgreSQL documentation there is an excerpt that mentions that you should run a VACUUM FULL when […]
How query errors affect Postgresql DB performance
Question : I have an application stored measurements data in PostgreSQL-12. Couple of processes write data by queries like: INSERT […]