Delete   Set public   Set private   Add tags   Delete tags
  Add tag   Cancel
  Delete tag   Cancel

Picture Wall - 144 pics

Keyset Cursors, Not Offsets, for Postgres Pagination
Rounding Numbers - Simple Talk
Uniqueness, Keys, and Identity - Simple Talk
Keyset pagination with descending order
Making a Postgres query 1,000 times faster - Mattermost
Transforming and Analyzing Data in PostgreSQL - Simple Talk
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2 - Simple Talk
Performance tuning: MAX and GROUP BY
Why CockroachDB doesn't use EvalPlanQual
A critique of ANSI SQL Isolation layers (Transaction Processing Book followup)
SQL Logic - Simple Talk
Eager Aggregation in SQL queries - Simple Talk
Speeding up partial COUNT(*) in Postgres by using LIMIT in a subquery
Subqueries and performance in PostgreSQL - CYBERTEC
The GROUP BY Clause - Simple Talk
Graphs in the Database: Rdbms In The Social Networks Age
Trees In The Database - Advanced data structures
Pagination and the problem of the total result count - CYBERTEC
Queries in PostgreSQL. Index scan / Habr
Postgres Query Optimization: LEFT JOIN vs UNION ALL
SQLreduce: Reduce verbose SQL queries to minimal examples - credativ®
PostgreSQL 15: Using MERGE in SQL - CYBERTEC
Data Normalization in PostgreSQL - CYBERTEC
Practical Examples of Data Normalization in PostgreSQL - CYBERTEC
Time-series compression algorithms, explained
Lesser Known PostgreSQL Features | Haki Benita
А deep dive into PostgreSQL query optimizations : Postgres Professional
WITH HOLD cursors and transactions in PostgreSQL - CYBERTEC
jsquery vs SQL/JSON | EDB
A UNIQUE experience - Simple Talk
How PostgreSQL aggregation works
Practical SQL for Data Analysis | Haki Benita
The Data School by Chartio
Some SQL Tricks of an Application DBA | Haki Benita
Modern Data Practice and the SQL Tradition | Florents Tselai
Courses - Carnegie Mellon Database Group
The SQL Murder Mystery
GitHub - lfittl/pg_query_go: Go library to parse and normalize SQL queries using the PostgreSQL query parser
Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP - Cybertec
Modeling Time - Simple Talk
Abusing SECURITY DEFINER functions - Cybertec
1-to-1 relationship in PostgreSQL for real - Cybertec
DECLARE CURSOR in PostgreSQL or how to reduce memory consumption - Cybertec
The Difference Between SQL’s JOIN .. ON Clause and the Where Clause – Java, SQL and jOOQ.
SQL Query Optimization for Large IN Queries – Mukul Chaware – Medium
GitHub - laowantong/mocodo: Modélisation Conceptuelle de Données. Nickel. Ni souris.
Calculating Weighted Averages When Joining Tables in SQL – Java, SQL and jOOQ.
GitHub - pjungwir/postgres-temporal-talk: My talk about Postgres and Temporal Databases
PostgreSQL Deep Dive: How Your Data Model Affects Storage
How to Emulate PERCENTILE_DISC in MySQL and Other RDBMS – Java, SQL and jOOQ.
Calculate Percentiles to Learn About Data Set Skew in SQL – Java, SQL and jOOQ.
COUNT(*) vs COUNT(1) vs COUNT(id) – Alexey Bashtanov PostgreSQL Blog
Empty Thoughts: Working with NULL - Simple Talk
How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage | Haki Benita
A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL" - Cybertec
What the SQL?! JOIN me at UNION Station
How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL – Java, SQL and jOOQ.
PGDay UK 2016 -- Performace for queries with grouping
On the benefits of sorted paths |
https://content.pivotal.io/white-papers/orca-a-modular-query-optimizer-architecture-for-big-data
Fetch First Rows Just Got Faster | Oracle Optimizer Blog
How to Use SQL UPDATE .. RETURNING to Run DML More Efficiently – Java, SQL and jOOQ.
How to Write a Multiplication Aggregate Function in SQL – Java, SQL and jOOQ.
How to Reduce Syntactic Overhead Using the SQL WINDOW Clause – Java, SQL and jOOQ.
Find the Next Non-NULL Row in a Series With SQL – Java, SQL and jOOQ.
Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Three - CrateDB
Transactional Data Operations in PostgreSQL Using Common Table Expressions – Rob Conery
Ask TOM "IN & EXISTS"
How SQL DISTINCT and ORDER BY are Related – Java, SQL and jOOQ.
How to store dates and times in PostgreSQL? – The system is the asset, code a liability – Medium
PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses – Java, SQL and jOOQ.
Introduction to Data Vault Modeling
Fun with SQL: Functions in Postgres
Missing Data - Simple Talk
Scalable incremental data aggregation on Postgres and Citus
Fun with SQL: Window functions in Postgres
Index skip scan | Oracle Scratchpad
CREATE VIEW vs. ALTER TABLE in PostgreSQL - Cybertec
PostgreSQL: Detecting periods of activity in a timeseries - Cybertec
Fun with SQL: Recursive CTEs in Postgres
Selecting all Columns Except One in PostgreSQL – Java, SQL and jOOQ.
avoid OR for better PostgreSQL query performance - Cybertec
Tech preview: PostgreSQL 11 - CREATE PROCEDURE - Cybertec
How does Stack Overflow do pagination? - Meta Stack Overflow
Advanced SQL: Why first_value and last_value are no bugs - Cybertec
Database constraints in Postgres: The last line of defense
PostgreSQL: Speeding up analytics and windowing functions
Repeatable Read Is Not Repeatable – Database Journal Club – Medium
New features for sequences: gains and pitfalls - Cybertec
Database migrations and Pum
Range Types & Recursion: How to Search Availability with PostgreSQL
PostgreSQL performance: How the optimizer handles views
Degree of Duplication - Simple Talk
CMU 15-445/645 :: Intro to Database Systems (Fall 2017)
CMU 15-721 :: Advanced Database Systems (Spring 2017)
SQL Keys in Depth
Validation, Verification, and Modification - Simple Talk
PostgreSQL: How to speed up GROUP BY and joins
Indexing with Postgres: When Less is More – PlanGrid Technology – Medium
Adding a NOT NULL CONSTRAINT on PG Faster with Minimal Locking
How do UPSERT and MERGE work in Oracle, SQL Server, PostgreSQL and MySQL | Vlad Mihalcea's Blog
How to Avoid Excessive Sorts in Window Functions – Java, SQL and jOOQ.
Faster bulk loading in Postgres with copy
Sql Antipatterns Strike Back
PostgreSQL Domain Integrity In Depth
Data Egret: PostgreSQL's transition relations.
GitHub - jarulraj/sqlcheck: Automatically identify anti-patterns in SQL queries
GitHub - dmtolpeko/sqlines: SQLines SQL Converter
10 Cool SQL Optimisations That do not Depend on the Cost Model – Java, SQL and jOOQ.
How to Write Efficient TOP N Queries in SQL – Java, SQL and jOOQ.
Missing Data - Joe Celko
JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage – Java, SQL and jOOQ.
SQL Code Smells - Simple Talk
Deferrable SQL Constraints in Depth
Star Transformation | Oracle Scratchpad
Simple SQL: Random Thoughts - Joe Celko
Principles of Sharding for Relational Databases
9 Reasons Why There Are No Foreign Keys in Your Database (Referential Integrity Checks)
Practical Guide to SQL Transaction Isolation
Average response time with Postgres’ Window Functions and CTEs
18+ Best Online Resources for Learning SQL and Database Concepts
Data in Motion and Data at Rest - Simple Talk - Joe Celko
Writing your own aggregation functions
PostgreSQL: Indexes and foreign keys
Analytics Playbook: Log Tables – Fishtown Analytics
SQL Data Aggregation Aggravation - Simple Talk - Joe Celko
Playing with Unicode
Efficient rollup tables with HyperLogLog in Postgres
Measurements, scales and encoding schemes - Joe Celko
Simple SQL: Attribute Splitting - Simple Talk - Joe Celko
PostgreSQL Conference - Schema management with Flyway
How to Generate at Least One Row in SQL – Java, SQL and jOOQ.
Some Great Things about PostgreSQL · Paul Ramsey
PostgreSQL and tablespaces - it's not so scary
SQL is 43 years old - here’s 8 reasons we still use it today | The Official SQLizer Blog
How to Calculate Multiple Aggregate Functions in a Single Query – Java, SQL and jOOQ.
Removing duplicate rows in PostgreSQL
Json in Postgres - The present and Future - ...
SQL IN Predicate: With IN List or With Array? Which is Faster? – Java, SQL and jOOQ.
Apprendre les bases de données et SQL
How to Benchmark Alternative SQL Queries to Find the Fastest Query – Java, SQL and jOOQ.
Faster SQL Through Occasionally Choosing Natural Keys Over Surrogate Keys – Java, SQL and jOOQ.
Impress Your Coworkers With the Incredible NATURAL FULL OUTER JOIN! – Java, SQL and jOOQ.
A Probably Incomplete, Comprehensive Guide to the Many Different Ways to JOIN Tables in SQL – Java, SQL and jOOQ.