Özkan Pakdil 🦖

@thejvmbender@techhub.social
245 Followers
859 Following
739 Posts

Software engineer, #java developer, #rust learner, JS writer,cpp/qt enjoyer, .net/c# fiddler. #postgresql #linux

Mostly post about #technology and #science and randomly funny things

Bloghttps://ozkanpakdil.github.io/
Gravatarhttps://gravatar.com/ozkanpakdil2

@thejvmbender Only thing I've seen is the blog they posted:

https://pganalyze.com/blog/postgres-18-async-io

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the default setting 'worker'.

pganalyze

@axboe I saw uring is getting used in #PostgreSQL , I wonder did you see any performance benchmarks or heard numbers maybe on with vs without uring ?

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c325a7633fcb33dbd73f46ddbbe91e95ddf3b227

I was reading this https://www.postgresql.org/message-id/45b4b689-0e78-4d30-a5f9-1a39d01ab2b7@ww-it.cn it is worth to share

GB18030 (China’s mandatory standard) uses 2 bytes per Chinese character vs. UTF-8’s 3—saving 33% storage. Legacy apps rely on it; new systems gain efficiency. UTF-8 rules globally, but regional mandates matter.

#PostgreSQL

Re: Retiring some encodings?

Hi Michael > Yeah, that's a good point. I would also question what's the benefit > in using GB18030 over …

PostgreSQL Mailing List Archives
How #AI decides whether you are a military target and why this already leads to more civilian casualties. Prof. Elke Schwarz on "workflow optimization" "20 seconds for human in the loop" and "target factory" (Broadcast by @tegenlicht in Dutch, although most is in English and YouTube can help with additional closed captions.) https://www.youtube.com/watch?v=0kNcjeyW7oU #notechforapartheid #responsibleai
Hoe AI bepaalt of jij een militair doelwit bent en waarom dit nu al tot meer burgerdoden leidt

YouTube
Working with a slow system is a huge problem, I forgot what was I planning to do 😊

#jetbrains junie is really good compared to others. AI for developers finally 🤓

https://ozkanpakdil.github.io/gpt/ai/development/tools/2025/05/18/junie.html

JetBrains Junie: Is It Better Than Other AI Coding Assistants?

My Journey with Junie: A Game-Changer for Developers

Software Engineer Özkan Pakdil
This code is coming from famous @venkats from his talk
https://www.youtube.com/watch?v=v5Q7TC5u5Co
Know Your Java?

YouTube

What is the output of below #java code
```java
int[] factor = new int[] { 2 };
var numbers = List.of(1, 2, 3);

var stream = numbers.stream()
.map(number -> number * factor[0]);
factor[0] = 0;
stream.forEach(System.out::print);
```

246
10.7%
000
82.1%
I do not know
7.1%
Poll ended at .

@lukas hey, I just saw https://pganalyze.com/blog/postgres-18-async-io very nice numbers I like it

I was also wondering, do you know any site shows #postgresql benchmark results version by version since pg 10, and of course with latest beta 18 and alpha 19 ? if exists 🤓

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the default setting 'worker'.

pganalyze
This is going to sound strange, but does anyone have a good code editor with git support for the iPad?