Anayrat links

Counting things at the speed of light with roaring bitmaps

PostgreSQL · RoaringBitmap · pg_roaringbitmap

December 15, 2023 at 3:17:28 PM GMT+1 * · permalink

https://www.postgresql.eu/events/pgconfeu2023/sessions/session/4762/slides/408/roaring.pdf

Getting the most out of pg_stat_io

pg_stat_io · PostgreSQL · pg16

December 15, 2023 at 2:27:57 PM GMT+1 * · permalink

https://www.postgresql.eu/events/pgconfeu2023/sessions/session/4774/slides/402/P-DBI-E-20231216-PGCONFEU-pg_stat_io.pdf

PostGIS Performance Tips

Postgis

December 6, 2023 at 12:21:29 PM GMT+1 * · permalink

https://youtu.be/GRbbn2voDyo

GitHub - jankapunkt/latexcv: :necktie: A collection of cv and resume templates written in LaTeX. Leave an issue if your language is not supported!

latex · cv

December 5, 2023 at 11:29:30 AM GMT+1 * · permalink

https://github.com/jankapunkt/latexcv

GitHub - dataegret/pg-utils: Useful PostgreSQL utilities

tools · PostgreSQL

November 20, 2023 at 10:55:07 AM GMT+1 * · permalink

https://github.com/dataegret/pg-utils/tree/master

Exploring a Postgres query plan | notes.eatonphil.com

PostgreSQL · Internal · hack · Extension · planner

November 19, 2023 at 10:23:13 PM GMT+1 * · permalink

https://notes.eatonphil.com/2023-11-19-exploring-a-postgres-query-plan.html

PostgreSQL IO Visibility: #wehack PostgreSQL Internals and pg_stat_io | Andrew Atkinson

PostgreSQL · pg_stat_io · pg16

November 1, 2023 at 9:44:16 PM GMT+1 * · permalink

https://andyatkinson.com/blog/2023/11/01/PostgreSQL-IO-Visibility-wehack-pg_stat_io

Unlock Your Arsenals: GDB Debugging Essentials with PostgreSQL - techbuddies.io

PostgreSQL · hack · GDB

October 30, 2023 at 9:39:50 AM GMT+1 * · permalink

https://www.techbuddies.io/2023/10/30/unlock-your-arsenals-gdb-debugging-essentials-with-postgresql/

The collation versioning problem with ICU 73

PostgreSQL · ICU

October 20, 2023 at 6:51:00 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2023/10/20/icu-73-versioning.html

JSON Path Operator Confusion

PostgreSQL · jsonpath · JSON

October 15, 2023 at 9:57:31 PM GMT+2 * · permalink

https://justatheory.com/2023/10/sql-jsonpath-operators/

Linux Kernel Teaching — The Linux Kernel documentation

linux · Kernel

October 13, 2023 at 1:50:16 PM GMT+2 * · permalink

https://linux-kernel-labs.github.io/refs/heads/master/index.html

Using traditional calendars with ICU

PostgreSQL · ICU

October 11, 2023 at 11:37:13 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2023/09/27/icu-traditional-calendars.html

pg_stat_io and PostgreSQL 16 performance

PostgreSQL · pg16 · pg_stat_io

October 6, 2023 at 8:42:58 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/pg_stat_io-postgresql-16-performance/

MERGE() - A Quick Introduction

PostgreSQL · MERGE · pg15

October 6, 2023 at 8:36:29 PM GMT+2 * · permalink

https://postgresql.us/events/pgconfnyc2023/sessions/session/1243/slides/94/PGNYC%20Merge.pdf

Ceph performance — YourcmcWiki

SSD

September 28, 2023 at 10:30:27 PM GMT+2 * · permalink

https://yourcmc.ru/wiki/Ceph_performance

Demystifying Database Transcations | Dinesh Gowda

PostgreSQL · MVCC · Isolation

September 28, 2023 at 9:04:31 PM GMT+2 * · permalink

https://dineshgowda.com/posts/demystifying-database-transcations/

PostgreSQL EXPLAIN Glossary - pgMustard

PostgreSQL · explain

September 27, 2023 at 5:09:56 PM GMT+2 * · permalink

https://www.pgmustard.com/docs/explain

Understanding EXPLAIN - part 1 - Costs and actual time | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL · explain

September 27, 2023 at 5:03:54 PM GMT+2 * · permalink

http://www.louisemeta.com/blog/explain/

PostgreSQL: Feature Matrix

PostgreSQL · versions

September 26, 2023 at 4:09:37 PM GMT+2 * · permalink

https://www.postgresql.org/about/featurematrix/

PostgreSQL major versions - pgPedia - a PostgreSQL Encyclopedia

PostgreSQL · versions

September 26, 2023 at 3:36:45 PM GMT+2 * · permalink

https://pgpedia.info/postgresql-versions/index.html