Anayrat links

1788 shaares

1788 shaares

Filters

86 / 90

Links per page

20 50 100

SQL IN Predicate: With IN List or With Array? Which is Faster? – Java, SQL and jOOQ.

SQL · PostgreSQL

March 30, 2017 at 9:05:47 PM GMT+2 * · permalink

https://blog.jooq.org/2017/03/30/sql-in-predicate-with-in-list-or-with-array-which-is-faster/

Ecrire et optimiser une requête SQL

PostgreSQL · SQL

March 30, 2017 at 9:24:46 AM GMT+2 * · permalink

http://pgphil.ovh/ecrire_optimiser_95_01.php

Grouping sets

PostgreSQL · SQL

March 30, 2017 at 9:24:34 AM GMT+2 * · permalink

http://pgphil.ovh/grouping_sets_10_devel.php

Hints

PostgreSQL

March 30, 2017 at 9:24:23 AM GMT+2 * · permalink

http://pgphil.ovh/hint_96_01.php

Apprendre les bases de données et SQL

SQL · Cours

March 29, 2017 at 8:38:11 PM GMT+2 * · permalink

https://sgbd.developpez.com/tutoriels/cours-complet-bdd-sql/

How to Benchmark Alternative SQL Queries to Find the Fastest Query – Java, SQL and jOOQ.

SQL

March 29, 2017 at 8:37:47 PM GMT+2 * · permalink

https://blog.jooq.org/2017/03/29/how-to-benchmark-alternative-sql-queries-to-find-the-fastest-query/

Data Egret: Deep dive into postgres stats: pg_stat_bgwriter reports

PostgreSQL · pg_stat_bgwriter

March 28, 2017 at 2:38:48 PM GMT+2 * · permalink

http://blog.postgresql-consulting.com/2017/03/deep-dive-into-postgres-stats_27.html

Combining Partitioning and FDWs for Real-Time Analytics - DZone Big Data

PostgreSQL · FDW

March 28, 2017 at 2:38:28 PM GMT+2 * · permalink

https://dzone.com/articles/combining-partitioning-and-fdws-for-real-time-anal

Writing Analytics SQL with Common Table Expressions –

PostgreSQL · SQL · CTE

March 26, 2017 at 4:12:47 PM GMT+2 * · permalink

https://research.neustar.biz/2014/05/19/writing-analytics-sql-with-common-table-expressions/

Bash quirks - Julia Evans

bash

March 26, 2017 at 3:58:14 PM GMT+2 * · permalink

https://jvns.ca/blog/2017/03/26/bash-quirks/

A git centered forge - Pagure

git

March 24, 2017 at 9:41:08 PM GMT+1 * · permalink

https://pagure.io/pagure

La puissance des workflows git – OVH UX Labs – Medium

git

March 24, 2017 at 9:37:41 PM GMT+1 * · permalink

https://medium.com/@OVHUXLabs/la-puissance-des-workflows-git-12e195cafe44#.aq7f1lv2n

Bruce Momjian: Referencing Select Column Aliases in Where Clauses

PostgreSQL · SQL

March 24, 2017 at 9:30:10 PM GMT+1 * · permalink

http://momjian.us/main/blogs/pgblog/2017.html#March_24_2017

Bruce Momjian: Characters Sets, Encodings, and Collations

PostgreSQL · SQL · Collation

March 24, 2017 at 9:28:49 PM GMT+1 * · permalink

http://momjian.us/main/blogs/pgblog/2017.html#March_22_2017

PG Phriday: CONFLICT of Interests | BonesMoses.org

PostgreSQL · SQL · UPSERT

March 24, 2017 at 9:27:59 PM GMT+1 * · permalink

http://bonesmoses.org/2017/03/24/pg-phriday-conflict-of-interests/

Adaptive query optimization

PostgreSQL · MachineLearning · Hack

March 21, 2017 at 2:59:30 PM GMT+1 * · permalink

https://github.com/tigvarts/aqo/blob/master/paper-draft.pdf

Bruce Momjian: Outer Joins and Where Clauses

PostgreSQL · SQL

March 20, 2017 at 6:14:27 PM GMT+1 * · permalink

http://momjian.us/main/blogs/pgblog/2017.html#March_20_2017

Faster SQL Through Occasionally Choosing Natural Keys Over Surrogate Keys – Java, SQL and jOOQ.

SQL

March 17, 2017 at 6:13:45 PM GMT+1 * · permalink

https://blog.jooq.org/2017/03/16/faster-sql-through-occasionally-choosing-natural-keys-over-surrogate-keys/

perf sched for Linux CPU scheduler analysis

perf

March 17, 2017 at 6:13:27 PM GMT+1 * · permalink

http://www.brendangregg.com/blog/2017-03-16/perf-sched.html

Robert Haas: Parallel Query v2

PostgreSQL · Internal

March 17, 2017 at 6:13:08 PM GMT+1 * · permalink

http://rhaas.blogspot.fr/2017/03/parallel-query-v2.html

Filters

86 / 90

Links per page

20 50 100