Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
afiskon
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
11 ms
·
1.
▲
Show HN: Feed2email.py
(github.com)
4 points
by
afiskon
9y ago
|
0 comments
2.
▲
Show HN: Pg_protobuf – Protobuf support for PostgreSQL
(afiskon.github.io)
7 points
by
afiskon
9y ago
|
0 comments
3.
▲
Show HN: PLFC – Programming Language for Cats
(github.com)
1 points
by
afiskon
9y ago
|
0 comments
4.
▲
by
afiskon
10y ago
More links (in Russian): http://rsdn.org/forum/life/6717583 + https://xakep.ru/2017/03/07/kris-kasperski-rip/ Wiki page about Kris https://en.wikipedia.org/wiki
5.
▲
Famous Russian hacker Kris Kaspersky passed away
(dropzone.com)
107 points
by
afiskon
10y ago
|
11 comments
6.
▲
by
afiskon
10y ago
Done https://news.ycombinator.com/item?id=12838767
7.
▲
by
afiskon
10y ago
@brudgers suggested to re-send this link as "Show HN" https://news.ycombinator.com/item?id=12834893 Sorry for a copy, unfortunately I'm unable to edit or delete an original submission.
8.
▲
Show HN: Vagrant replacement in ~250 lines of code in Python 3
(github.com)
6 points
by
afiskon
10y ago
|
2 comments
9.
▲
by
afiskon
10y ago
Thanks for advice. I'll try it!
10.
▲
Vagrant replacement in ~250 lines of code in Python 3
(github.com)
2 points
by
afiskon
10y ago
|
3 comments
11.
▲
by
afiskon
10y ago
Very interesting. For some reason I always thought that no one runs PostgreSQL on ZFS. If it's not a secret, what company uses PostgreSQL on FreeBSD like this?
12.
▲
by
afiskon
10y ago
Frankly I don't remember, it was more then half a year ago. LZ4 is a LZ77 family algorithm which means its dictionary is a "shifting window". I don't believe such kind of dictionary will fit in this case.
13.
▲
by
afiskon
10y ago
No, I didn't test it on ZFS. Sorry for asking, but is there any reason to run DBMS (which I would like to remind has a build-in compression) on ZFS which itself is a small DBMS? Sounds like too much unnecessary overhead to me.
14.
▲
by
afiskon
10y ago
Thank you for an interesting idea! I can't promise I will implement it myself any time soon, however. You know the saying - pull requests are welcome :)
15.
▲
by
afiskon
10y ago
I'm afraid Snappy will not help, at least a lot. PostgreSQL already has a build-in compression (PGLZ). I tested various different algorithms before this shared-dictionary-idea - lz4, bzip and others. Some compress a bit better, other a
16.
▲
by
afiskon
10y ago
Frankly I don't remember all details since I did this benchmark in February. IIRC its "ZSON + PGLZ" vs "JSONB + PGLZ". Please note that everything depends very much on your data. PostgreSQL is smart about what to c
17.
▲
ZSON, PostgreSQL extension for compressing JSONB
(postgresql.org)
136 points
by
afiskon
10y ago
|
13 comments
18.
▲
Criticizing the Rust Language, and Why C/C++ Will Never Die
(viva64.com)
78 points
by
afiskon
11y ago
|
83 comments