Anayrat links

PostgreSQL: [PATCH] Equivalence Class Filters

PostgreSQL · planner · Equivalence_Classes

February 7, 2019 at 2:53:55 PM GMT+1 * · permalink

https://www.postgresql.org/message-id/flat/CAKJS1f9FK_X_5HKcPcSeimy16Owe3EmPmmGsGWLcKkj_rW9s6A%40mail.gmail.com

PostgreSQL: Equivalence Classes when using IN

PostgreSQL · planner · Equivalence_Classes

February 7, 2019 at 2:05:42 PM GMT+1 * · permalink

https://www.postgresql.org/message-id/VI1PR05MB1709E0E0ADE98AFC0D8D2177C7770%40VI1PR05MB1709.eurprd05.prod.outlook.com

What are custom and generic plans in PostgreSQL? - Blog dbi services

PostgreSQL · prepare · planner

February 6, 2019 at 9:21:14 AM GMT+1 * · permalink

https://blog.dbi-services.com/what-are-custom-and-generic-plans-in-postgresql/

SortSupport: Sorting in Postgres at Speed — Brandur Leach

PostgreSQL · Internal · hack · sort

February 4, 2019 at 6:27:50 PM GMT+1 * · permalink

https://brandur.org/sortsupport

Transparent Data Encryptoin in PostgreSQL and Integratino with Key Ma…

PostgreSQL · Security · Encryption

February 1, 2019 at 12:21:51 PM GMT+1 * · permalink

https://www.slideshare.net/masahikosawada98/transparent-data-encryptoin-in-postgresql-and-integratino-with-key-management-service

Evolution of the x86 context switch in Linux – MaiZure's Projects

linux · System

January 29, 2019 at 6:40:22 PM GMT+1 * · permalink

http://www.maizure.org/projects/evolution_x86_context_switch_linux/

How to Emulate PERCENTILE_DISC in MySQL and Other RDBMS – Java, SQL and jOOQ.

SQL · Window_function

January 28, 2019 at 11:46:22 AM GMT+1 * · permalink

https://blog.jooq.org/2019/01/28/how-to-emulate-percentile_disc-in-mysql-and-other-rdbms/

Calculate Percentiles to Learn About Data Set Skew in SQL – Java, SQL and jOOQ.

SQL · Window_function

January 26, 2019 at 4:30:49 PM GMT+1 * · permalink

https://blog.jooq.org/2019/01/22/calculate-percentiles-to-learn-about-data-set-skew-in-sql/

COUNT(*) vs COUNT(1) vs COUNT(id) – Alexey Bashtanov PostgreSQL Blog

SQL · PostgreSQL

January 25, 2019 at 9:09:50 AM GMT+1 * · permalink

https://pgblog.bashtanov.com/2019/01/24/count-vs-count1-vs-countid/

GitHub - petergeoghegan/benchmarksql: Unofficial mirror of BenchmarkSQL PostgreSQL TPC-C fair-use implementation

PostgreSQL · benchmark

January 24, 2019 at 10:43:24 AM GMT+1 * · permalink

https://github.com/petergeoghegan/benchmarksql

GitHub - hjacobs/kubernetes-failure-stories: Compilation of public failure/horror stories related to Kubernetes

Kubernetes

January 24, 2019 at 10:13:44 AM GMT+1 * · permalink

https://github.com/hjacobs/kubernetes-failure-stories

The Database Programmer: normalization

SQL · normalisation · denormalisation

January 24, 2019 at 10:13:04 AM GMT+1 * · permalink

http://database-programmer.blogspot.com/search/label/normalization

90 days of AWS EKS in Production - kubedex.com

Kubernetes

January 21, 2019 at 3:28:50 PM GMT+1 * · permalink

https://kubedex.com/90-days-of-aws-eks-in-production/

Tagging Trillions of Users in Milliseconds with varbitx on PostgreSQL

PostgreSQL · Extension

January 21, 2019 at 2:49:01 PM GMT+1 * · permalink

https://medium.com/@Alibaba_Cloud/tagging-trillions-of-users-in-milliseconds-with-varbitx-on-postgresql-1109c372d892

Temporal features in SQL:2011

SQL · Publication · PERIOD

January 20, 2019 at 10:04:59 PM GMT+1 * · permalink

http://cs.ulb.ac.be/public/_media/teaching/infoh415/tempfeaturessql2011.pdf

GitHub - stressapptest/stressapptest: Stressful Application Test - userspace memory and IO test

linux · benchmark

January 17, 2019 at 12:44:03 PM GMT+1 * · permalink

https://github.com/stressapptest/stressapptest

SageDB: a learned database system | the morning paper

Publication · database · learned

January 16, 2019 at 9:08:25 AM GMT+1 * · permalink

https://blog.acolyer.org/2019/01/16/sagedb-a-learned-database-system/

GitHub - kostiantyn-nemchenko/ansible-role-patroni: Ansible Role for Patroni

Patroni · ansible

January 15, 2019 at 4:51:43 PM GMT+1 * · permalink

https://github.com/kostiantyn-nemchenko/ansible-role-patroni

GitHub - kubernetes-sigs/kubespray: Deploy a Production Ready Kubernetes Cluster

Kubernetes · ansible

January 15, 2019 at 3:04:32 PM GMT+1 * · permalink

https://github.com/kubernetes-sigs/kubespray

Maintaining feature branches and submitting patches with Git |

PostgreSQL · git

January 15, 2019 at 2:05:50 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/maintaining-feature-branches-submitting-patches-git/