Ilmar Kerm

@franckpachot.bsky.social Hroug misses you

Ilmar Kerm reposted

Mirela Ardelean

@mirelarooug.bsky.social

17 Sept

The #octemea26 #CASOUG part ends today with the event in Dushanbe @ilmarkerm.eu @nassyambasha.bsky.social Zaheer Syed, Rustam Khodzhaev @oracleace.bsky.social @oracleugs.bsky.social

Ilmar Kerm reposted

Mirela Ardelean

@mirelarooug.bsky.social

14 Sept

Today started the first part of #octemea26 with the #CASOUG events. First stop: Bishkek @ilmarkerm.eu @nassyambasha.bsky.social Rustam Khodzhaev, Aynura Zhanuzakova, Zaheer Syed, Oleg Faynitskiy @oracleace.bsky.social @oracleugs.bsky.social

11 Sept

@alexnuijten.bsky.social i hope the photo reminds you the taste again

8 Sept

Ok, now I have spent well over 5 hours on getting TLS working on Oracle 26. I think it is working now. And I'm pretty experienced on TLS, even on Oracle. Will continue with mTLS tomorrow... and then I'll also spend 5 minutes on setting up TLS on Postgres.

8 Sept

Measuring PostgreSQL read replica lag (hot standby) with synchronous_commit=remote_write. To estimate the write lag on replica when preparing to turn on pgDog query load balancing. At 1400-1500 write tps, single thread, 60min test run. Need to investigate these tail ends.

8 Sept

By "replica lag" I mean the time the written data from primary is successfully queried from replica.

4 Sept

Database conference has started #POUG2026

youtu.beWas It Right for Us to Be Treated Like This In Estonia? YouTube video by Touring With The Kids

14 Aug

Millions for a single flight ticket!

These Brits claim “Uzbek plov” is local Estonian food? Doesn’t it say right in the name that it is Uzbek? youtu.be/usA93ivLMN0?... and coming from unbearable heatwave complaining about rain and cold. And I’ve only watched 2:40 so far.

4 Aug

No, “cheburek” is not local food at all.

4 Aug

And then straight to the Nevski cathedral with glowing reviews. Home of the Russian aggressors. Painful to watch. cancel.

4 Aug

aww, thanks headhunder. i think i've been working on that team for over 19 years now.

Climate change- southern Western Europe is burning 40+, we in the north have unusually cold summer, like 15-17 and rain

26 July

Exceptionally slow coffee machine on Sõru-Triigi ferry, mine took like 1 min. The silent passive aggressive queue forms, the silence and looks… and the next 1 min brew starts.

17 July

Another unintuitive temporal nugget. Documented ofcourse. EXTRACT() from TIMESTAMP WITH TIME ZONE returns values in UTC!

ilmarkerm.euTIMESTAMP WITH TIME ZONE and covering indexes – Ilmar Kerm

17 July

Blogged about Oracle! ilmarkerm.eu/blog/2026/07...

17 July

I so much hate when someone (more managerial) send a page - "I generated this using AI, please fact check it". I always end up deleting all/most of it and rewriting since the information is just wrong and it uses so many words. Huge waste in time and resources.

16 July

The dreaded PostgreSQL "cached plan must not change result type" and connection pooling (pgBouncer). Looks like I have to build something that notifies pool that DDL has happened and reconnect backends. Or pgDog, but then I have a CREATE ROLE notification problem. Could contribute to pgDog.

16 July

OAuth and other SSO are great... Until their secrets expire and noone has notified.

22 June

Cool, managed to find the limit of bigfile tablespace (in 16k block size database). "alter tablespace dw_etl_data maxsize 65t" - ORA-740 datafiue size of xx blocks exceeds maximum file size

dutchnews.nlUS tech firms share Dutch regulator officials’ names with senate - DutchNews.nlCompanies such as Microsoft and Meta have shared the names of civil servants and academics working on European tech regulation with a senate committee investigating “tech censorship” or “jawboning”, n...

4 June

Has anyone used Percona MongoDB server? I think they just take MongoDB community edition source and merge their own features on top? I'm just interested in auditing.

Ilmar Kerm reposted

Irve

@irve.bsky.social

3 June

Riik pilvest välja! www.dutchnews.nl/2026/05/us-t...

1 June

pgDog deployed to prod... lets see

All good

Amazing, first time I'm seeing "terminate my membership" is selected as default and one click was enough.

18 Apr

Quote from a dinner table ”she is my primary key, but I have many foreign keys”

14 Apr

#netflix how does advertising qualify as “legitimate interest“? Haven’t really used Netflix for a while, time to exit?

12 Apr

More and more stuff finding its way to moving boxes and trash. Hardly any space to move in my apartment. #movingSucks

7 Apr

Looks like etcd 3.5.28 breaks patroni - Failed to get list of machines - etcdserver: user name is empty. etcd is authenticated. 3.5.29 does not help, downgrade helps.

github.comAuthorization bypasses in multiple APIs### Impact _What kind of vulnerability is it? Who is impacted?_ Multiple vulnerabilities allow unauthorized users to bypass authentication or authorization checks and call certain etcd function...

7 Apr

probably this github.com/etcd-io/etcd...

github.cometcd3: UserEmpty error crash when etcd authentication is enabled dynamically (missing @_handle_auth_errors) · Issue #3581 · patroni/patroniWhat happened? The Bug When Patroni is running against an etcd3 cluster, and etcd authentication is enabled dynamically (mid-lifecycle), Patroni crashes with an etcdserver: user name is empty error...

7 Apr

i see, fixed but not yet released github.com/patroni/patr...

31 Mar

I saw a table in my old project "dual_replacement" and thought it must be veeery old. Now I see a comment in a view that did not compile anymore "Here it uses dual_replacement because since 19c it seems that when doing DML against view it checks that all referred tables have write privileges"

Amusement for today, letting LLM to rewrite internal documentation to style mixing Linkedin speak and Shakespeare. "A question worth synergizing upon!" "THE PLOT THICKENS: A STRATEGIC NARRATIVE"

"Should the gateway's performance prove insufficient—and mark my words, it often doth—then code refactoring becomes thy destiny." "A significant investment? Verily. Worth the ROI? Data-dependent, forsooth!"

"Thus concludes our architectural journey. The stage is set; the play's the thing. Let thy organization now execute with purpose and passion!"

Amusement for today, letting LLM to rewrite internal documentation to style mixing Linkedin speak and Shakespeare. "A question worth synergizing upon!" "THE PLOT THICKENS: A STRATEGIC NARRATIVE"

"To gateway or not to gateway—that is NOT the question. Rather, 'tis: Can our infrastructure bear the computational burden?"

27 Mar

The only thing worth mentioning in the new software version… is “8 new emojis”? 🤦

19 Mar

Dear Microslop, you seem to be pushing the large slop generators everywhere, but could you please add one where is would actually be needed - search in Teams.

youtube.comA Day in the Life of an Ensh*ttificatorYouTube video by Forbrukerrådet Norge

9 Mar

Haven’t heard that before, approved. ”Now with AI-free commentary” youtu.be/s84W8_VtAOY?...

@dohdatabase.com has problems with 42

Ilmar Kerm reposted

Irve

@irve.bsky.social

27 Feb

Replying to @irve.bsky.social

Ja ühtlasi ka mõnus reklaamvideo pasastaja elukutsest: www.youtube.com/watch?v=T4Up...

24 Feb

Tomorrow is the day, when my 10+ years long Microsoft Office subscription expires. #excited #microslop

22 Feb

/me survived a 2h Zwift ride

22 Feb

Trying to put bike-fitted measurement on my Cannondale Topstone XL, measurements say hoods to saddle (where width is 80mm) must be 888mm, best i can do is 840mm :( Looks like my only options are Canyon Grizl 7 CL XXL or custom build. Noone else does so crazy reaches.

15 Feb

I have reached the ultimate enlightenment #level42

11 Feb

Just funny 🤦‍♂️ "CPUQuota={{ cpu_count*100 }}%" turned into "CPUQuota=5555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555%"