Anayrat links

9 Reasons Why There Are No Foreign Keys in Your Database (Referential Integrity Checks)

SQL

August 9, 2017 at 5:00:27 PM GMT+2 * · permalink

https://dataedo.com/blog/why-there-are-no-foreign-keys-in-your-database-referential-integrity-checks

Linux Load Averages: Solving the Mystery

linux

August 9, 2017 at 4:47:09 PM GMT+2 * · permalink

http://www.brendangregg.com/blog/2017-08-08/linux-load-averages.html

SQL Regression Tests

PostgreSQL · SQL

August 9, 2017 at 2:10:09 PM GMT+2 * · permalink

http://tapoueh.org/blog/2017/08/sql-regression-tests/

Learning at work - Julia Evans

Programming

August 8, 2017 at 8:51:10 AM GMT+2 * · permalink

https://jvns.ca/blog/2017/08/06/learning-at-work/

Postgres vs. Oracle access paths IV - Order By and Index - Blog dbi services

PostgreSQL · Oracle · Performance

August 6, 2017 at 9:44:58 PM GMT+2 * · permalink

https://blog.dbi-services.com/postgres-vs-oracle-access-paths-iv/

Experimenting with scaling and full parallelism in PostgreSQL

PostgreSQL · Performance

August 6, 2017 at 9:44:33 PM GMT+2 * · permalink

http://www.cybertec.at/experimenting-scaling-full-parallelism-postgresql/

Figuring out how to contribute to open source - Julia Evans

August 6, 2017 at 9:44:14 PM GMT+2 * · permalink

https://jvns.ca/blog/2017/08/06/contributing-to-open-source/

Installation d'une solution mail complète sous Debian 9 Stretch - Tetsumaki Blog

debian · Mail · Spam

August 3, 2017 at 9:31:29 AM GMT+2 * · permalink

https://blog.tetsumaki.net/articles/2017/08/installation-dune-solution-mail-complete-sous-debian-9-stretch.html

Practical Guide to SQL Transaction Isolation

SQL · PostgreSQL · Isolation

August 2, 2017 at 2:35:22 PM GMT+2 * · permalink

https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html

Postgres 9.4 feature highlight - lossy/exact pages for bitmap heap scan

PostgreSQL · Internal

August 2, 2017 at 2:06:44 PM GMT+2 * · permalink

http://paquier.xyz/postgresql-2/postgres-9-4-feature-highlight-lossyexact-pages-for-bitmap-heap-scan/

Re: any way to get rid of Bitmap Heap Scan recheck?

Signification du lossy lors d'un bitmapheapscan

PostgreSQL · Internal

August 2, 2017 at 2:06:12 PM GMT+2 * · permalink

https://www.postgresql.org/message-id/464F3C5D.2000700@enterprisedb.com

What’s new in PostgreSQL 10? Part 2 – Native Partitioning | Postgres Miktzoanim Israel

PostgreSQL · v10 · partionning

August 2, 2017 at 11:04:03 AM GMT+2 * · permalink

https://postgrespro.co.il/blog/whats-new-in-postgresql-10-part-2-native-partitioning/

Sysdig | Container isolation gone wrong

Virtualisation · Docker · Container

August 2, 2017 at 11:03:42 AM GMT+2 * · permalink

https://sysdig.com/blog/container-isolation-gone-wrong/

When To Avoid JSONB In A PostgreSQL Schema - Heap Blog

PostgreSQL · JSON

August 1, 2017 at 2:14:25 PM GMT+2 * · permalink

https://blog.heapanalytics.com/when-to-avoid-jsonb-in-a-postgresql-schema/

CiteSeerX — Design and evaluation of main memory hash join algorithms for multi-core CPUs

Research · not_read · Hash · Join

August 1, 2017 at 12:34:03 PM GMT+2 * · permalink

http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.225.3495

12 Things Developers Will Love About Oracle Database 12c Release 2 | Oracle All Things SQL Blog

Oracle · 12.2

July 31, 2017 at 9:20:59 PM GMT+2 * · permalink

https://blogs.oracle.com/sql/12-things-developers-will-love-about-oracle-database-12c-release-2

https://www.slideshare.net/morgo/mysql-80-optimizer-guide

MySQL · Performance

July 31, 2017 at 9:13:45 PM GMT+2 * · permalink

https://www.slideshare.net/morgo/mysql-80-optimizer-guide

Average response time with Postgres’ Window Functions and CTEs

PostgreSQL · CTE · SQL

July 31, 2017 at 2:16:09 PM GMT+2 * · permalink

https://medium.com/@chamini2/average-response-time-with-postgres-window-functions-and-ctes-a19adb7ed4f7

1.1 Billion Taxi Rides with BrytlytDB & 2 GPU-Powered p2.16xlarge EC2 Instances

GPU · Performance · PostgreSQL

July 31, 2017 at 2:15:52 PM GMT+2 * · permalink

http://tech.marksblogg.com/billion-nyc-taxi-rides-aws-ec2-p2-16xlarge-brytlytdb.html

GitHub - martingms/vipsql: A vim-frontend for interacting with psql

PostgreSQL · psql

July 31, 2017 at 2:15:10 PM GMT+2 * · permalink

https://github.com/martingms/vipsql