sickpig

6 ms·

1.
by sickpig 10y 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 aut
2.
PostgreSQL 9.6 RC 1 Released(postgresql.org)
5 points by sickpig 10y ago|1 comments
3.
by sickpig 10y ago
http://serverfault.com/questions/769357/recovering-from-a-rm... "luckily we recovered almost all data!"
4.
by sickpig 10y 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/Inco
5.
Postgresql:Generate parallel sequential scan plans in simple cases(postgresql.org)
7 points by sickpig 11y ago|0 comments
6.
by sickpig 11y ago
https://www.gnu.org/software/apl/
7.
by sickpig 11y 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.
8.
by sickpig 11y 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
9.
by sickpig 11y 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 /
10.
by sickpig 11y 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 their
11.
by sickpig 11y ago
This is the third time in a week that this article is posted on hn See: https://news.ycombinator.com/item?id=9371854 https://news.ycombinator.com/item?id=9375978 It seems to be a real hot-button to say the
12.
by sickpig 11y ago
Already posted and discussed here a few hours ago: https://news.ycombinator.com/item?id=9371854
13.
by sickpig 11y 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
14.
PostgreSQL 9.5 will have native sharding(depesz.com)
42 points by sickpig 11y ago|4 comments
15.
by sickpig 11y 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
16.
by sickpig 11y ago
The main function of prisons is to keep the criminals away from law-abiding society Really? I thought it was about correcting/reforming.
17.
by sickpig 12y ago
Yes you're right when talking about the steady dicrease in terms of full nodes. I think that introducing economic incentives for stimulate full node operators are badly needed. I've recently read a proposal for such a scheme writt
18.
by sickpig 12y ago
Users could use SPV clients in case of resource constraints, on the other hand there are incentives in place, that till now, have kept miners from shutting down their nodes. Bitcoin core latest version (0.10.0) have reduced significantly th
19.
by sickpig 12y ago
I stand corrected, you're right. I'm supposed to know better.
20.
by sickpig 12y ago
from the article: He admits the models will never be perfect, but thinks that even a model that’s only right about 50 percent of the time could help investors and entrepreneurs avoid particularly bad ideas dunno why but I can't sto
21.
by sickpig 12y ago
Ok now I got what you meant. thanks for the explanation. Having said that your consideration about "on line nature" applies also to my mastercard in almost all the shops I usually buy stuff be it on line or off line. Without me pr
22.
by sickpig 12y ago
You sure really do know a lot about cryptocurrencies. I'm particularly interested in their "intrinsic on line nature", care to elaborate a little bit further?
23.
by sickpig 12y ago
50$ of transaction fee? At current price that means 0.075 btc per tx. I can assure you that you can mv btc from one address to another for a lot less. Even without paying any fee at all. It all depends on how "old" are the btc you
24.
by sickpig 12y ago
other useful resources on using PostgresSQL on a Linux server with a ZFS filesystem: - http://adpgtech.blogspot.it/2013/04/linuxzfs-is-great.html - http://wiki.postgresql.org/images/8/86&
25.
by sickpig 13y ago
I would add http://www.freespeechme.org/ to the mix, very interesting use of namecoin to register a .bit domain
26.
by sickpig 13y ago
localbitcoins?
27.
by sickpig 13y ago
stealth address, coinjoin and mixing services are already here and people can/should start using immidiately
28.
by sickpig 13y ago
or cryptocurrency in general as soon as porn industries will start to accept doge/lite/max/whatever coin
29.
by sickpig 13y ago
Really? So what happens if I shut down the central authority?
30.
by sickpig 13y ago
FWIW even the industrial revolution had a huge environmental impacts.

More ›