Pavel Stehule's blog
Some notes about PostgreSQL
Pages
(Move to ...)
Home
▼
Wednesday, March 20, 2024
compiled win x64 dll of orafce-4.9.3 and plpgsql_check-2.7.4 for PostgreSQL 15 and 16
›
I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16. Setup: download orafce-4.9.3-x...
Tuesday, March 5, 2024
How fast is plpgsql?
›
Ten years ago I did some speed tests of plpgsql . I did same tests on same computer, and now, the plpgsql is about 3-4 times faster. There i...
Sunday, March 3, 2024
using jq for processing PostgreSQL logs in json format
›
PostgreSQL supports logging in json format. From my perspective json logs are badly readable, but allows machine processing, and with good t...
Thursday, February 8, 2024
new extension pgmeminfo
›
I wrote very simple extension pgmeminfo for PostgreSQL12+, that should to help with investigation of memory usage by Postgres. Function pgm...
Friday, December 29, 2023
2023 resume
›
rewriting dbms_pipe and dbms_alert in orafce. Now the conditions variables are used (for synchronization) instead timeouts, and the lags in...
Wednesday, December 6, 2023
Close cursors
›
One my customer reported very problematic memory issues of currently tested code freshly ported from Oracle's PL/SQL to PL/pgSQL. He rew...
1 comment:
Friday, October 13, 2023
compiled dll of plpgsql_check 2.5.4 and Orafce 4.7.0 for PostgreSQL 15 and 16
›
I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16. Setup: download orafce-4.7.0-x...
›
Home
View web version