sickpig

Joined 14 years ago

Karma
384
Submissions
59
Member since
May 15
[ my public key: https://keybase.io/sickpig; my proof: https://keybase.io/sickpig/sigs/NhGo_0zgq9NoE97TTFVxuXv_5n2SJRH58-0SpVIQAp8 ]
View on Hacker News

Recent submissions

Comment · 10 years ago
To have a look at what's new in 9.6 see: https://wiki.postgresql.org/wiki/Newin96

Quick list of major features:

Parallel sequential scans, joins and aggregates

Elimination of repetitive scanning of old data by autovacuum

Synchronous replication now allows multiple standby servers for increased reliability

Full-text search for phrases

Support for remote joins, sorts, and updates in postgres_fdw

Substantial performance improvements, especially in the area of improving scalability on many-CPU servers

Comment · 10 years ago
Comment · 10 years ago
average is skewed towards distribution outliers, the more asymmetric the distribution the more pronounced will be such effect.

On the other hand median just gives you the value that split the distribution in two exact parts.

Price/Income distributions are the perfect match if you want to see avg bias taken to its extreme.

e.g.

median of [2,2,2,2,2,2,2,100] = 2 average of [2,2,2,2,2,2,2,100] = 14.25

Comment · 11 years ago
Comment · 11 years ago
Bringing down a government does not belong to the same group of consequences the precautionary principle is applied to.

PP is used when a system, in this case the humanity, is at risk of total failure, i.e. ruin.

Comment · 11 years ago
Strange nobody mentioned Nassim Taleb and his work on that matter: The Precautionary Principle - www.fooledbyrandomness.com/pp2.pdf

Quoting the first paragraph of the paper:

The precautionary principle (PP) states that if an action or policy has a suspected risk of causing severe harm to the public domain (affecting general health or the environment globally), the action should not be taken in the absence of scientific near-certainty about its safety. Under these conditions, the burden of proof about absence of harm falls on those proposing an action, not those opposing it. PP is intended to deal with uncertainty and risk in cases where the absence of evidence and the incompleteness of scientific knowledge carries profound implications and in the presence of risks of "black swans", unforeseen and unforeseable events of extreme consequence.

Comment · 11 years ago
Untraceable money is an oxymoron, the whole point of money is that the whole network of people using it, can trust it is not forged out of someones ass, and is instead what its claimed to be.

Quick someone tell the federal reserve / ecb that QEs can't be used because they are an oxymoron (sorry can't resist).

That said it is possible to have an open ledger used to avoid duble spends without revealing anything about someone finance, just look for monero (xmr) or zerocash.

Comment · 11 years ago
Dave Pell is really influential among people who read hn imho, so yes NextDraft network effect could have played a role here.

That said I think jurnos really like this kind of narrative and subject, since it's really appealing to theirs audience.

It's a sort feedback loop that time will help to "break".

Comment · 11 years ago
Comment · 11 years ago
Comment · 11 years ago
I don't know about "web" scale, but it will definitely scale horizontally without using any external tools/extensions.

There's still a somewhat annoying limitation that is related to the status of table partitioning in postgresql.

In fact the planner automatically choose the right child table, be it on the same db or into another server, for UPDATE and SELECT statements but not for INSERTs. This is a known limitation and there's active work to fix it but don't hold your breath though.

Comment · 11 years ago
They should change name from correctional facilities to something else then.

Joking aside, I think that using prisons just for isolation is a waste of tax payer money.

Just think about at the case at hand, we are wasting the money needed to keep this guy in jail for another 8 decades with no actual reasons.

edit: fix grammar

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton