Search: [SQL] - Anayrat links

Keyset Cursors, Not Offsets, for Postgres Pagination

SQL · offset

December 16, 2024 at 10:59:16 GMT+1 * · permalink

https://blog.sequinstream.com/keyset-cursors-not-offsets-for-postgres-pagination/

Rounding Numbers - Simple Talk

SQL · celko · not_read

September 23, 2024 at 14:02:16 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/theory-and-design/rounding-numbers/

Uniqueness, Keys, and Identity - Simple Talk

SQL · not_read · celko

September 11, 2024 at 20:40:02 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/theory-and-design/uniqueness-keys-and-identity/

Keyset pagination with descending order

PostgreSQL · SQL · offset · pagination

July 16, 2024 at 19:50:41 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/keyset-pagination-with-descending-order/

Making a Postgres query 1,000 times faster - Mattermost

Row Constructor Comparison

https://dba.stackexchange.com/questions/241591/postgres-choosing-a-filter-instead-of-index-cond-when-or-is-involved

TL;DR : x > a OR (x == a AND y > b) to (x, y) > (a, b)

PostgreSQL · optimizer · Tricks · SQL · not_read · row

May 18, 2024 at 21:24:54 GMT+2 * · permalink

https://mattermost.com/blog/making-a-postgres-query-1000-times-faster/

Transforming and Analyzing Data in PostgreSQL - Simple Talk

PostgreSQL · SQL · CTE · Window_function

April 25, 2024 at 13:30:38 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/transforming-and-analyzing-data-in-postgresql/

Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2 - Simple Talk

PostgreSQL · CTE · SQL · Window_function

April 17, 2024 at 11:53:38 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/using-common-table-expressions-transforming-and-analyzing-data-in-postgresql-part-2/

Performance tuning: MAX and GROUP BY

PostgreSQL · SQL · skip · loose_index_scan · CTE · RECURSIVE · Lateral

April 10, 2024 at 13:08:52 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/performance-tuning/

Why CockroachDB doesn't use EvalPlanQual

PostgreSQL · MVCC · Isolation · SQL · EvalPlanQual · CockroachDB

April 6, 2024 at 10:45:55 GMT+2 * · permalink

https://www.cockroachlabs.com/blog/why-cockroachdb-doesnt-use-evalplanqual/

Teach planner and executor about monotonic window funcs

PostgreSQL · Window_function · pg15 · SQL

April 5, 2024 at 17:54:56 GMT+2 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=9d9c02ccd

A critique of ANSI SQL Isolation layers (Transaction Processing Book followup)

SQL · Isolation

April 4, 2024 at 18:24:51 GMT+2 * · permalink

https://muratbuffalo.blogspot.com/2024/04/a-critique-of-ansi-sql-isolation-layers.html

SQL Logic - Simple Talk

SQL · celko

March 29, 2024 at 20:05:34 GMT+1 * · permalink

https://www.red-gate.com/simple-talk/databases/theory-and-design/sql-logic/

Eager Aggregation in SQL queries - Simple Talk

PostgreSQL · Aggregate · SQL · tips · Tricks · group_by

February 29, 2024 at 10:17:35 GMT+1 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/eager-aggregation-in-sql-queries/

Speeding up partial COUNT(*) in Postgres by using LIMIT in a subquery

PostgreSQL · SQL · Tricks

February 24, 2024 at 20:46:43 GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-limited-count

SELECT 'amazing_features' FROM "postgresql"

SQL · PostgreSQL · CTE · Lateral · Modern_SQL

February 4, 2024 at 10:40:13 GMT+1 * · permalink

https://download.davinkevin.fr/presentations/select-amazing-features-from-postgresql/snowcamp-2024/select-amazing-features-from-postgresql.pdf

Subqueries and performance in PostgreSQL - CYBERTEC

PostgreSQL · SQL · exists · optimizer

July 11, 2023 at 11:47:17 GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/subqueries-and-performance-in-postgresql/

The GROUP BY Clause - Simple Talk

SQL · group_by

July 11, 2023 at 00:09:31 GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/theory-and-design/the-group-by-clause/

TIL - IN is not the same as ANY

PostgreSQL · IN · SQL

July 5, 2023 at 11:51:19 GMT+2 * · permalink

https://kmoppel.github.io/2023-07-04-til-in-is-not-the-same-as-any/

Graphs in the Database: Rdbms In The Social Networks Age

SQL · GraphDB · RECURSIVE · CTE

February 23, 2023 at 18:54:21 GMT+1 * · permalink

https://www.slideshare.net/quipo/rdbms-in-the-social-networks-age

Trees In The Database - Advanced data structures

SQL · GraphDB · CTE · RECURSIVE

February 23, 2023 at 18:54:03 GMT+1 * · permalink

https://www.slideshare.net/quipo/trees-in-the-database-advanced-data-structures