961
Does Postgres Scale?
Benchmarking the workflow execution and workflow queueing scalability of a single Postgres server.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
962
Updates to the H2O.ai db-benchmark
The H2O.ai db-benchmark has been updated with new results. In addition, the AWS EC2 instance used for benchmarking has been changed to a c6id.metal for improved repeatability and fairness across libraries. DuckDB is the fastest library for both join and group by queries at almost every data size.
963
Elasticsearch 6.0.0 GA released
With 2236 pull requests by 333 commiters added since the release of Elasticsearch 5.0.0, we are proud to announce the release of Elasticsearch 6.0.0 GA, based on Lucene 7.0.1.
964
965
Migrating 23TB from S3 to B2 in 7 hours
Nodecraft moved 23TB of customer backup files from AWS S3 to Backblaze B2 in just 7 hours, and saved big on egrees fees with Cloudflare's Bandwidth Alliance.
966
PyPy's New JSON Parser
Introduction In the last year or two I have worked on and off on making PyPy's JSON faster, particularly when parsing large JSON files. I...
967
Is Postgres read heavy or write heavy?
A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.
968
969
Machine Learning 101: An Intro to Utilizing Decision Trees
Stay up-to-date with the latest news, practical tips & best practices from Qlik on data analytics, data integration, data literacy, and big data analytics.
970
971
Data Infrastructure at IFTTT
Get more from the services you love on IFTTT. Explore the latest tips and tricks, browse by category, or search by name.
972
Postgres tips for Rails developers
At RailsConf, the Citus engineering team found themselves sharing lots of useful Postgres tips on how to debug and improve the performance of your Postgres database from your Rails app. Includes topics like long-running queries, misbehaving queries, pg_stat_statements, pgBouncer, and more.
973
PostgreSQL 9.3 Beta 1 Released
The first beta release of PostgreSQL 9.3, the latest version of the world's best open source database, is now available. …
974
How Wikipedia influences judicial behavior
Mixed appraisals of one of the Internet’s great friends (or foes), Wikipedia, are reflected in the slightly dystopian article “List of Wikipedia Scandals”, which sits below a Wikipedia web address. Scrutiny aside, billions of users routinely flock to the online, anonymously editable encyclopedia knowledge bank for…
975
976
977
978
How we saved money by replacing Mixpanel with BigQuery and K8S
Insights, guides, and product updates from Cloud Intelligence™.
979
People Keep Inventing Prolly Trees
A novel data structure has been invented four times now, with three different names. We think that's a good sign.
980
981
982
983
Polars: Company Formation Announcement
We are excited to announce the start of company that will build around Polars, enabling data processing at any scale.
984
985
Microsoft’s visual data explorer SandDance open sourced
SandDance, the beloved data visualization tool from Microsoft Research, has been re-released as an open source project on GitHub.
986
An all-sky map of half a million supermassive black holes
The Black Hole Mapper reaches a milestone with its first southern hemisphere optical observations, coordinated eROSITA X-ray identification, and multi-epoch tracking of accreting black holes across the universe.
987
988
Time-Series Compression Algorithms
These algorithms aren't magic – but combined they can save over 90% of storage costs and speed up queries. Here’s how 5 common ones work.
989
SQLite Release 3.39.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
990
Build an Air Quality Monitor with InfluxDB, Grafana and Docker on a Raspberry Pi
balenaSense reads temperature- humidity- barometric pressure- and air quality- and provides a dashboard that you can access from anywhere.