Pages

▼
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:
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...
2 comments:
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...