hans_castorp

5 ms·

1.
by hans_castorp 1mo ago
The Postgres devs rejected it, because it wasn't part of the standard back then, and apparently work was going on, to include it into the standard. Now that it's included in the standard, there is work to implement it: https:&#x2
2.
by hans_castorp 2mo ago
I frowned over the "none of it looked planned" - the whole description sounds as if that swim was exactly that: planned from the beginning.
3.
by hans_castorp 2mo ago
Typically no. In most (all?) cases the pooler manages one pool per database user, so even if there was something leaking, it would not be anything that the database user couldn't access anyway. But if you are paranoid, you can configur
4.
by hans_castorp 2mo ago
Their license only disallows publishing the result of a benchmark But you were always allowed to run your own benchmarks internally. Back then, you could have installed 10gR1 and 10gR2 and compare the sort performance on identical data sets
5.
by hans_castorp 2mo ago
> Maps and satnav require a web connection. No they don't require a network at all. The only drawback if there is no network is that the initial finding of the position takes longer. And maps can be downloaded so that they are avail
6.
Commodore 64 Basic for PostgreSQL(thombrown.blogspot.com)
72 points by hans_castorp 3mo ago|11 comments
7.
by hans_castorp 5mo ago
A side note on pgBackRest: PGX created a fork and announced to maintain it under the name pgxbackup: https://thebuild.com/blog/2026/05/01/pgxbackup-continuity-su...
8.
by hans_castorp 5mo ago
German citizen as well. So with a Jolla phone and Linux laptop, I am left in the cold.
9.
by hans_castorp 6mo ago
> If you want something that is more like actual recursion (I.e., depth-first), Oracle has CONNECT BY which does not require the same kind of tracking. It also comes with extra features to help with cycle detection, stack depth reflectio
10.
by hans_castorp 7mo ago
Ah, didn't see the caching part. Plans for prepared statements are cached though.
11.
by hans_castorp 7mo ago
> and it has no way to serialize a query plan to some form that can be shared between processes https://www.postgresql.org/docs/current/parallel-query.html "PostgreSQL can devise query plans that can lever
12.
by hans_castorp 8mo ago
This is simply not true. Some people are investigated because they spread lies, insults and threats. Things that would be investigated (and punished) as well, if done "off line". The freedom of speech does not mean "freedom t
13.
by hans_castorp 8mo ago
Postgres does index de-duplication. So it's likely that even if you change the strings to enums, the index won't be that much smaller. > Furthermore, why have two indexes with the same leading field (status)? That indeed is a v
14.
by hans_castorp 8mo ago
Can we please stop calling it "sideloading"? It's simply "installing" software on hardware that I own, and that I should have full control over.
15.
by hans_castorp 8mo ago
No relational database implements syntax highlighting. The tools you use to write and execute SQL queries implement that.
16.
by hans_castorp 8mo ago
Or use a hand as a 5-bit integer, then you can count to 31 :)
17.
by hans_castorp 8mo ago
I was going to refer to the new Jolla Phone, but then I realized that it doesn't have a headphone jack.
18.
by hans_castorp 8mo ago
It does if you look into the README for Firefox https://github.com/corbindavenport/just-the-browser/tree/mai...
19.
by hans_castorp 8mo ago
Graphene only runs on Pixel phones
20.
by hans_castorp 9mo ago
So what's his "Drill, baby, drill" about? He thinks renewable energy is the something sent by the anti-christ. The only energy source he accepts is burning fossil fuels or nuclear power.
21.
by hans_castorp 9mo ago
The convicted felon in the White House doesn't give a shit about drug criminals - he just pardoned one. He is after Venezuela's oil.
22.
by hans_castorp 9mo ago
Would be cool if that could be integrated into Postgres :)
23.
by hans_castorp 9mo ago
With the latest Postgres version (>= 18) you do NOT need a plugin
24.
by hans_castorp 9mo ago
I have seen a lot of people sort by (generated) integer values to return the rows "in creation order" assuming that sorting by an integer is somehow magically faster than sorting by a proper timestamp value (which give a more robu
25.
by hans_castorp 9mo ago
For those that can read German, here is a little article that explains some of the obstacles over time: https://www.derstandard.at/story/3000000299789/traum-vom-sue...
26.
by hans_castorp 10mo ago
I don't have any "social media" accounts. I guess they won't believe me, and would deny me a visa based on the assumption that I am lying.
27.
by hans_castorp 10mo ago
The German Wikipedia page[1] about the Z1 also contains a quote from Kurt Pannke, who Zuse told about his plans for the computer. "Oh, Mr Zuse, there is absolutely nothing left to invent in the field of calculating machines. But you ar
28.
by hans_castorp 11mo ago
Direct I/O is being worked on, but is not yet available. See e.g. here: https://www.cybertec-postgresql.com/en/postgresql-18-and-bey...
29.
by hans_castorp 11mo ago
Hmm, works for me (but maybe that's my uBlock or PrivacyBadger)
30.
by hans_castorp 11mo ago
You need a / at the end of the URL https://www.mjt.me.uk/posts/falsehoods-programmers-believe-a...

More ›