Anayrat links

Simulate sun shadows

meteo

January 26, 2024 at 7:46:47 PM GMT+1 * · permalink

https://shademap.app/

How to partition Postgres tables by timestamp based UUIDs

uuid · partition_pruning · partionning · PostgreSQL

January 18, 2024 at 2:39:02 PM GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-partition-tables-time-based-UUID

ZLinky_TIC Antenne_externe Non

domotic

January 5, 2024 at 1:20:26 PM GMT+1 * · permalink

https://lixee.fr/produits/37-zigate-usb-ttl-3770014375148.html

Zero downtime Postgres upgrades | Knock

PostgreSQL · logique · Replication · Upgrade

January 4, 2024 at 11:44:55 AM GMT+1 * · permalink

https://knock.app/blog/zero-downtime-postgres-upgrades

Migrate date functions from Oracle to Amazon RDS for PostgreSQL | AWS Database Blog

PostgreSQL · Migration · Oracle

January 4, 2024 at 11:08:25 AM GMT+1 * · permalink

https://aws.amazon.com/blogs/database/migrate-date-functions-from-oracle-to-amazon-rds-for-postgresql/

Harnessing pg_vector for Building a Recommendation System in Postgres | by Syfe Tech | Jan, 2024 | Medium

PostgreSQL · vector · pgvector

January 3, 2024 at 11:38:26 AM GMT+1 * · permalink

https://medium.com/@syfe.tech/harnessing-pg-vector-for-building-a-recommendation-system-in-postgres-2cde7891f938

Zero Downtime PostgreSQL Upgrades

Upgrade · PostgreSQL · gitlab · logique · Replication

January 3, 2024 at 11:32:52 AM GMT+1 * · permalink

https://www.postgresql.eu/events/pgconfeu2023/sessions/session/4791/slides/439/2023.pgconf.eu%20Zero%20Downtime%20PostgreSQL%20Upgrades.pdf

BliKVM v4 Allwinner | blicube

kvm

January 2, 2024 at 1:13:54 PM GMT+1 * · permalink

https://www.blicube.com/blikvm-v4-allwinner/

Transaction Isolation in Postgres, explained

PostgreSQL · Isolation · MVCC

December 20, 2023 at 11:08:25 AM GMT+1 * · permalink

https://www.thenile.dev/blog/transaction-isolation-postgres

Converting MySQL to PostgreSQL - Wikibooks, open books for an open world

MySQL · PostgreSQL · Migration

December 18, 2023 at 2:00:53 PM GMT+1 * · permalink

https://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL

Breaking Up with Massive Tables via Partitioning

PostgreSQL · pgconfeu2023 · pgconfeu · partionning

December 18, 2023 at 12:23:20 PM GMT+1 * · permalink

https://www.postgresql.eu/events/pgconfeu2023/sessions/session/4699/slides/438/Breaking%20Up%20Massive%20Tables%20with%20Partitioning.pdf

How to Convert PostgreSQL Streaming Replication to Logical Replication

PostgreSQL · logique · Replication

December 16, 2023 at 8:50:24 PM GMT+1 * · permalink

https://www.percona.com/blog/how-to-convert-postgresql-streaming-replication-to-logical-replication/

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/