zX41ZdbW

59 ms·

841.
by zX41ZdbW 6y ago
+ more details: https://gh.clickhouse.tech/explorer/
842.
Show HN: Insights on GitHub Ecosystem with ClickHouse(github.com)
2 points by zX41ZdbW 6y ago|1 comments
843.
by zX41ZdbW 6y ago
The tool provides instant interactive queries on GitHub events dataset (3.1 billion events from 2011 till today).
844.
by zX41ZdbW 6y ago
"Pull panda" for your repository: https://gh-api.clickhouse.tech/play?user=play#c2VsZWN0IGNvdW... (replace condition on repo_name to your favorite repo)
845.
by zX41ZdbW 6y ago
Yes, 80 vCPU are logical cores, but ClickHouse is using the number of threads equal to the number of physical cores by default (40 threads). This is a reasonable default - when setting up the number of threads to full vCPU count, performanc
846.
by zX41ZdbW 6y ago
The downloadable dataset was created two days ago and the queries were run on this dataset. Data on https://gh-api.clickhouse.tech/play (for interactive queries) is updated every hour as described in the article, but downlo
847.
by zX41ZdbW 6y ago
Most of Linux kernel development happens on maillists and pull requests on GitHub are just for lulz.
848.
by zX41ZdbW 6y ago
It is single cloud instance (Yandex Cloud, 80 vCPU Intel Cascade Lake, network storage).
849.
Everything You Always Wanted to Know About GitHub (But Were Afraid to Ask)(gh.clickhouse.tech)
48 points by zX41ZdbW 6y ago|13 comments
850.
by zX41ZdbW 6y ago
ClickHouse presentations are almost 100% in HTML [1]. All of them are based on Shower [2] and to prepare a new presentation I just copy-paste previous presentation and edit HTML directly... actually very understandable and convenient even f
851.
by zX41ZdbW 6y ago
Also you can check it with the `write` syscall (just write a byte pointed by address to /dev/null). If a pointer is invalid, it will return setting errno to EFAULT.
852.
by zX41ZdbW 6y ago
It can be done easier with sigsetjmp, siglongjmp.
853.
by zX41ZdbW 6y ago
https://alexey-milovidov.github.io/font-selector/ for some decent coverage.
854.
by zX41ZdbW 6y ago
The change to Ryu is here: https://github.com/ClickHouse-Extras/ryu/pull/1
855.
by zX41ZdbW 6y ago
In ClickHouse* we patched Ryu to provide nicer representations and to have better performance for floats that appear to be integers. * https://github.com/ClickHouse/ClickHouse/pull/8542
856.
by zX41ZdbW 6y ago
ClickHouse has been comparatively tested on Graviton2 as well as other types of ARM servers: https://clickhouse.tech/benchmark/hardware/
857.
by zX41ZdbW 6y ago
How does it compare in performance with the optimized code from ClickHouse? https://github.com/ClickHouse/ClickHouse/blob/c0fef71507b43c...
858.
I need extra C/C++ performance now. How?(danlark.org)
4 points by zX41ZdbW 6y ago|2 comments
859.
by zX41ZdbW 6y ago
Follow-up: https://news.ycombinator.com/item?id=23990844
860.
by zX41ZdbW 6y ago
Instructions, scripts and log can be found here: https://github.com/ClickHouse/ClickHouse/tree/master/benchma...
861.
Testing OmniSci on web analytics workload(presentations.clickhouse.tech)
2 points by zX41ZdbW 6y ago|1 comments
862.
ClickHouse and ColumnStore in the Star Schema Benchmark(percona.com)
6 points by zX41ZdbW 6y ago|1 comments
863.
by zX41ZdbW 6y ago
Yes, it's intended for desktop/laptop - where you write code.
864.
by zX41ZdbW 6y ago
There is good similar project that does it: https://www.programmingfonts.org/
865.
Monospace Font Selector(alexey-milovidov.github.io)
11 points by zX41ZdbW 6y ago|4 comments
866.
by zX41ZdbW 7y ago
Example of generic COW implementation in C++: https://github.com/ClickHouse/ClickHouse/blob/master/dbms/sr...
867.
Five Methods for Database Obfuscation(habr.com)
11 points by zX41ZdbW 7y ago|0 comments
868.
by zX41ZdbW 7y ago
There is a video named "The Secrets of ClickHouse Performance Optimizations": https://youtu.be/ZOZQCQEtrz8
869.
by zX41ZdbW 7y ago
> 116 billion rows per second at 233.61GB/s The numbers on sticker are from a cluster of 400 servers and 200 servers were participated in query execution.
870.
by zX41ZdbW 7y ago
You can also use ClickHouse to query files directly - with clickhouse-local tool. Example: https://www.altinity.com/blog/2019/6/11/clickhouse-local-the...

More ›