Hacker News Reader

i_have_to_speakon German men 18-45 need military permit for extended stays abroad

TBF that is an isolated incident, not a distinguishing trait of a species.

i_have_to_speakon German men 18-45 need military permit for extended stays abroad

Are homo sapiens the only species that organizes themselves into tribes and work towards the destruction of other tribes of same species?

i_have_to_speakon PostgresBench: A Reproducible Benchmark for Postgres Services

This is a great initiative. Benchmarking managed services is notoriously tricky due to varying configurations and 'black-box' optimizations. For anyone looking to run these benchmarks on their own or wanting to dive deeper into the why behind the numbers, pgmetrics (https://pgmetrics.io) is a fantastic open-source tool. It collects a massive amount of internal PG stats into a structured JSON format, making it easy to see exactly what's happening during a load test. For a more persistent and visual way to track these metrics across different providers, pgDash (https://pgdash.io) is built on top of that same data.

i_have_to_speakon High memory usage in Postgres is good

Great write-up—the distinction between healthy OS caching and actual memory pressure is often misunderstood. To get a granular view of where your memory is actually going (shared buffers, cache hits, etc.) without the overhead of heavy agents, pgmetrics (https://pgmetrics.io) is very effective. If you need to track these metrics over time to catch when 'good' caching turns into 'bad' pressure, pgDash (https://pgdash.io) builds directly on top of it to provide a specialized monitoring dashboard with zero-config setup.

i_have_to_speakon Show HN: Postgres extension for BM25 relevance-ranked full-text search

This looks like a great addition to the Postgres ecosystem. When adding specialized extensions like this, it's always worth keeping an eye on how they impact overall system performance, especially memory usage and lock contention as the dataset grows. For anyone testing this out, I'd recommend using an open-source tool like *pgmetrics* (https://pgmetrics.io) to get a baseline and then monitor how the new indexes and search workloads affect your underlying metrics. It’s zero-dependency and gives you a very deep look into the internals without much overhead.

i_have_to_speakon I found the perfect yearly calendar (for me)

You might like this static full year planner version: https://pgdash.io/2026

i_have_to_speakon 1 Trillion Web Pages Archived

Is there an index of all these pages?

i_have_to_speakon A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING

This really has nothing to do with CTEs.

The SQL standard does not specify how many times a subquery must or can be run. In this case, Postgres is free to run the uncorrelated subquery many times. Unfortunately, the subquery result is not idempotent.

The real solution is not to rely on the optimizer for the correctness of your query. The query should be logically correct, irrespective of the query plan, right? The correct solution would be to ensure that the subquery runs only once, using a materialized cte or temp table. Do not base your "solution" on the discovery that for this particular version of Postgres, the planner runs this type of subquery once for the '=' operator and multiple times for 'IN'.

i_have_to_speakon They make USB-C cables with displays now

> The paranoid side of me suspects that a cable like this one would be an ideal place to hide a malicious chip.

Why hide a malicious chip in a cable with display -- why not in one without a display? Wouldn't that be more, uh, malicious?

i_have_to_speakon Show HN: Nano-web – a low latency one binary webserver designed for serving SPAs

h2o (https://h2o.examp1e.net/index.html) is a full-fledged, single-binary, open source web server. Check it out.

i_have_to_speakon US aircraft shoots down new airborne object over Canada

99 Luftballons.. As Griffin would say, "uh oh, we're in this one"..

i_have_to_speakon Herb Kelleher: Manage in Good Times So You'll Do Well in the Bad Times (2006)

Title needs a "(2006)" suffix.

i_have_to_speakon DigitalOcean Region Information

> BLR1 - NTT Communications Mumbai DC6

Uh, pretty sure the Bangalore data center is not in Mumbai.

i_have_to_speakon Ask HN: Why don't file systems and OS's provide file system transactions?

> Quite frankly, I don't know why filesystems don't provide these things.

They do. F2FS [1] does. There were attempts to add them to xfs/ext4 too, but they petered out, probably because of lack of interest.

[1] https://www.kernel.org/doc/html/latest/filesystems/f2fs.html

i_have_to_speakon Zim – A Desktop Wiki

It is/was awesome! -- http://theguide.sourceforge.net/

i_have_to_speakon Monitoring 27kw Generac Generator with Raspberry Pi and Multimode Fiber

OK, i have to ask: why not just use a wifi-enabled pi? Maybe with a repeater inside the garage?

i_have_to_speakon Why you can't solve knowledge problems with information tools alone

> Maybe as much as 80% of the knowledge in an organisation is undocumented

That's a bold claim. Any pointers to the research behind this?

i_have_to_speakon Index bloat reduced in PostgreSQL v14

A bunch of Postgres pain points: https://pgdash.io/blog/postgresql-six-not-so-easy-pieces.htm...

i_have_to_speakon Generics enabled by default in Go tip

It is available in Go 1.17 with a flag, use:

    go run -gcflags=-G=3 foo.go

i_have_to_speakon Putting an Ultra-Tiny Linux Board in a Phone Charger Eventually

Whatever happened to SheevaPlug [1] ?

[1] https://en.wikipedia.org/wiki/SheevaPlug

i_have_to_speakon Basic Telemetry for Audacity

Here we go again.

Follow Rocky Linux's path and start a community fork!

i_have_to_speakon Postgres Observability

pgmetrics [1] is an open source tool that can collect information from most of the views/functions described here. Can emit that information in text or JSON formats.

[1] https://pgmetrics.io

i_have_to_speakon Show HN: I built FabHomePages so your home can have its own homepage in minutes

Oh, it's ((FabHome)Pages), not (Fab(HomePages)). Hmm.

i_have_to_speakon The impact on middleware of expanding APIs with Go's interface smuggling

> People can work around this for HTTP middleware because they can make files build only on specific minimum versions of Go. Your package doesn't have this magical power; it's something available only for new APIs in the Go standard library.

It is indeed possible to add build constraints to .go files to have them included for compilation only on specified minimum versions of Go, see [1]

[1] https://golang.org/pkg/go/build/#hdr-Build_Constraints

i_have_to_speakon Gocker: Docker implemented in 1.3k lines of Go

Here's one in 100 lines of bash called, what else, "bocker": https://github.com/p8952/bocker

i_have_to_speakon India coronavirus: The 'mystery' of low Covid-19 death rates

When New York went in to lockdown, it had ~7000 cases (20th March) [1]

When UK went in to lockdown, it had 6700 cases. (23rd March) [2]

When India went in to lockdown, it had 657 cases. (25th March) [2]

[1] https://edition.cnn.com/2020/03/20/politics/new-york-workfor... [2] https://coronavirus.jhu.edu/map.html

i_have_to_speakon India coronavirus: The 'mystery' of low Covid-19 death rates

Ah yet another cant-be-true-they're-hiding-something article? Surely they can't be doing better than developed countries?

FWIW, India did implement a stronger lockdown much earlier on in the curve than other countries. State and federal authorities went lock-step in their actions, and with consistent messaging. Police enforced the lockdown at times even brutally, getting the point across to the general public. Indians watched UK and US struggle through a denial and late response in disbelief, like watching a car crash in slow motion.

i_have_to_speakon PostgreSQL Features to Try

Foreign keys for partitions is coming in Postgres 12: https://www.depesz.com/2019/04/24/waiting-for-postgresql-12-...

i_have_to_speakon Facebook backtracks after removing Warren ads calling for Facebook breakup

> the budget was so small ($100)

Really? The article says: "The ads were limited in size and reach, with each costing under $100, according to disclosure details listed online." Each ad was "under $100," and there are no details as to the exact extent of reach. The total spend could have easily been a few hundred grand.