Anayrat links

GitHub - gperftools/gperftools: Main gperftools repository

perf · profiling

April 12, 2021 at 2:07:54 PM GMT+2 * · permalink

https://github.com/gperftools/gperftools

GitHub - xwmx/nb: CLI plain-text note-taking, bookmarking, and archiving with encryption, filtering and search, Git-backed versioning and syncing, Pandoc-backed conversion, and more in a single portable script.

markdown · doc

April 6, 2021 at 4:24:35 PM GMT+2 * · permalink

https://github.com/xwmx/nb

Spatial Indexing for OSM in PostGIS

Postgis · PostgreSQL · GiST · SP-GIST · BRIN · index

April 5, 2021 at 8:04:41 PM GMT+2 * · permalink

https://slides.com/fxku/sotm19/fullscreen

WAL in PostgreSQL: 1. Buffer Cache

PostgreSQL · Internal · WAL

April 1, 2021 at 6:48:04 PM GMT+2 * · permalink

https://postgrespro.com/blog/pgsql/5967951

Practical Go Lessons

golang

March 24, 2021 at 9:45:55 PM GMT+1 * · permalink

https://www.practical-go-lessons.com

SQL Forever

SQL · Datawarehouse · Opendata

March 19, 2021 at 5:34:46 PM GMT+1 * · permalink

http://sqlforever.com/

Postgres Observability

PostgreSQL · monitoring

March 13, 2021 at 8:40:51 PM GMT+1 * · permalink

https://pgstats.dev/

How many engineers does it take to make subscripting work? · Erthalion's blog

PostgreSQL · pg14 · JSON · types

March 3, 2021 at 11:16:02 AM GMT+1 * · permalink

https://erthalion.info/2021/03/03/subscripting/

GitHub - microsoft/DataMigrationTeam: Repository for the Data Migration Team

Oracle · PostgreSQL · Migration · MSQLServer

March 2, 2021 at 4:29:29 PM GMT+1 * · permalink

https://github.com/microsoft/DataMigrationTeam

Migrating database storage objects from Oracle to Postgres - Microsoft Tech Community

Migration · PostgreSQL · Oracle

February 26, 2021 at 5:51:01 PM GMT+1 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/migrating-database-storage-objects-from-oracle-to-postgres/ba-p/2117312

20 outils webs indispensables pour développeurs

tools

February 17, 2021 at 9:52:19 AM GMT+1 * · permalink

https://www.jesuisundev.com/20-outils-webs/

PostgreSQL TOAST Data Corruption (ERROR: unexpected chunk number) – Luca Ferrari – Open Source advocate, human being

PostgreSQL · Internal · toast

February 10, 2021 at 2:24:31 PM GMT+1 * · permalink

https://fluca1978.github.io/2021/02/08/PostgreSQLToastCorruption.html

Always-on Profiling for Production Systems | 0x.tools

performance · perf · System · linux

February 5, 2021 at 4:03:53 PM GMT+1 * · permalink

https://0x.tools/

Evolution of tree data structures for indexing: more exciting than it sounds · Erthalion's blog

PostgreSQL · not_read · index · Btree · Internal

February 1, 2021 at 4:31:10 PM GMT+1 * · permalink

https://erthalion.info/2020/11/28/evolution-of-btree-index-am

Achieving 11M IOPS & 66 GB/s IO on a Single ThreadRipper Workstation - Tanel Poder Consulting

linux · NVMe · Kernel · fio

January 29, 2021 at 3:47:59 PM GMT+1 * · permalink

https://tanelpoder.com/posts/11m-iops-with-10-ssds-on-amd-threadripper-pro-workstation/

Re-Introducing Hash Indexes in PostgreSQL | Haki Benita

PostgreSQL · index · Hash

January 18, 2021 at 5:18:15 PM GMT+1 * · permalink

https://hakibenita.com/postgresql-hash-index

Some SQL Tricks of an Application DBA | Haki Benita

Tricks · PostgreSQL · SQL

January 15, 2021 at 3:08:19 PM GMT+1 * · permalink

https://hakibenita.com/sql-tricks-application-dba

Compare 535 Static Analysis Tools For All Programming Languages

Python · golang · C · rust

January 14, 2021 at 6:29:06 PM GMT+1 * · permalink

https://analysis-tools.dev/

Table of Contents - Rust Cookbook

rust

January 10, 2021 at 6:02:10 PM GMT+1 * · permalink

https://rust-lang-nursery.github.io/rust-cookbook/intro.html

Evolution of tree data structures for indexing: more exciting than it sounds · Erthalion's blog

PostgreSQL · sort · Btree · Algorithm · index · Research

December 28, 2020 at 5:14:31 PM GMT+1 * · permalink

https://erthalion.info/2020/11/28/evolution-of-btree-index-am/