Andres Freund (Tech) Profile
Andres Freund (Tech)

@AndresFreundTec

Followers
11K
Following
796
Media
45
Statuses
2K

FWD: @[email protected] FWD: https://t.co/DcPdStYfus Postgres developer, working at Microsoft. For politics: @AndresFreundPol

Western Massachusetts
Joined August 2017
Don't wanna be here? Send us removal request.
@AndresFreundTec
Andres Freund (Tech)
9 months
Of course that's just when one there's a new HW generation announced but not yet shipping.
0
0
6
@AndresFreundTec
Andres Freund (Tech)
9 months
The mac mini I was using for postgres CI died. I suspect the PSU. Too old for warranty. And I don't (yet) have the right screwdrivers to open it open. I guess I could put it under a drillpress. :/.
5
1
15
@AndresFreundTec
Andres Freund (Tech)
9 months
Tweet media one
0
0
0
@AndresFreundTec
Andres Freund (Tech)
9 months
(the context is Postgres CI).
1
0
1
@AndresFreundTec
Andres Freund (Tech)
9 months
Is there a way to get a license to run more than two macOS VMs on one host?.
1
0
2
@AndresFreundTec
Andres Freund (Tech)
9 months
Just gave a talk about improving postgres on NUMA systems:.
4
13
86
@AndresFreundTec
Andres Freund (Tech)
9 months
Would like to showcase some scalability problems + solution that I see with such queries, but right now it's mostly visible with queries I made up on my own. It's easy enough to make up workloads that show almost anything, so I'd rather use something designed by someone else.
2
0
4
@AndresFreundTec
Andres Freund (Tech)
9 months
Does anybody have a recommendation for a decent read-heavy/only "OLTP-ish" database benchmark where the queries aren't just single-table point or range selects?.
2
0
6
@AndresFreundTec
Andres Freund (Tech)
1 year
@ADATATechnology my SX8200PNP seems to ignore FUA on writes. Is that a) expected b) also the case on newer drives?.
0
0
4
@AndresFreundTec
Andres Freund (Tech)
1 year
The background is that I'd like to switch to using O_DSYNC by default for postgres' WAL, but that it appears some drives react unfavorably.
1
0
5
@AndresFreundTec
Andres Freund (Tech)
1 year
Command to run and the collected results are at.
Tweet card summary image
gist.github.com
SSD durable write latency. GitHub Gist: instantly share code, notes, and snippets.
1
1
4
@AndresFreundTec
Andres Freund (Tech)
1 year
Any chance a few folks could run the following fio command on various SSDs and tell me the latency, drive model and filesystem?.
5
7
19
@AndresFreundTec
Andres Freund (Tech)
1 year
RT @ahl: What an Oxide and Friends last night! @bcantrill and I were joined by the one and only @AndresFreundTec to talk about his discove….
0
24
0
@AndresFreundTec
Andres Freund (Tech)
1 year
RT @bl4sty: the xz sshd backdoor rabbithole goes quite a bit deeper. I was just able to trigger some harder to reach functionality of the b….
0
991
0
@AndresFreundTec
Andres Freund (Tech)
1 year
RT @AndresFreundTec: @binitamshah FWIW, I didn't actually start looking due to the 500ms - I started looking when I saw failing ssh logins….
0
265
0
@AndresFreundTec
Andres Freund (Tech)
1 year
RT @AminovDanielle: We have been reverse engineering the XZ Utils backdoor and are sharing some initial findings: we've identified multiple….
0
281
0
@AndresFreundTec
Andres Freund (Tech)
1 year
But I am certain that lots of experienced OSS devs can think of a few large and crucial projects where they fairly easily could have hidden something small in a larger change. Without a lot of prior contributions to the project.
4
2
67
@AndresFreundTec
Andres Freund (Tech)
1 year
I am a bit concerned by all the focus on small-ish projects with overwhelmed maintainers. There indeed are a lot of problems in that area.
2
7
94