Pages

▼
Saturday, April 19, 2025

Article about PostgreSQL 18

›
I wrote an article about PostgreSQL 18.  It is in Czech language, but translators from Czech to English, German, ... works relatively well t...
Saturday, March 29, 2025

How to fix Hibernate bug by conditional index

›
Yesterday I found significant grow of seq read tuples. After some investigation I found query with strange predicate: WHERE 1 = case when p...
Thursday, February 27, 2025

fresh plpgsql_check 2.7.15 for PostgreSQL 16, 17 for MS Windows

›
  I compiled and uploaded zip files plpgsql_check for PostgreSQL 16 and PostgreSQL 17 - I used Microsoft Visual C 2022. Setup: download plp...
2 comments:
Wednesday, February 5, 2025

plpgsql_check, raise warning when syntax of plpgsql expression is not pure

›
Originally the PL/pgSQL was very simple language and integration procedural language with SQL was very primitive. Very specific feature of P...
Monday, December 2, 2024

compiled win x64 dll of orafce-4.14.0 and plpgsql_check-2.7.12 for PostgreSQL 16 and 17

›
I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 16 and PostgreSQL 17 - I used Microsoft Visual C 202...
Friday, September 6, 2024

How to get info about relations between system tables?

›
One my customer asked me "what tables holds references to table pg_roles"? The reply is simple - none. pg_roles is view. But this ...
1 comment:
Thursday, June 6, 2024

More complex log in json format processing

›
 I needed to summarize number of bugs per week per user JSON log entry looks like: {"timestamp":"2024-06-07 00:10:56.525 C...
2 comments: