Anayrat links

Robert Haas: Collation Stability

PostgreSQL · Collation · ICU

November 29, 2021 at 11:35:59 PM GMT+1 * · permalink

http://rhaas.blogspot.com/2021/11/collation-stability.html

What developers find surprising about Postgres transactions | Lawrence Jones

PostgreSQL · xact · MVCC

November 29, 2021 at 10:56:47 AM GMT+1 * · permalink

https://blog.lawrencejones.dev/isolation-levels/

Installation de Frigate dans un LXC Proxmox

proxmox

November 29, 2021 at 10:56:21 AM GMT+1 * · permalink

https://domopi.eu/installation-de-frigate-dans-un-lxc-proxmox/

Announcing PyCaret’s New Time Series Module

datascience · TimeSeries · Python

November 15, 2021 at 10:34:47 AM GMT+1 * · permalink

https://towardsdatascience.com/announcing-pycarets-new-time-series-module-b6e724d4636c

Lesser Known PostgreSQL Features | Haki Benita

PostgreSQL · Tricks · SQL

November 8, 2021 at 4:58:02 PM GMT+1 * · permalink

https://hakibenita.com/postgresql-unknown-features

GitHub - pikvm/pikvm: Open and cheap DIY IP-KVM based on Raspberry Pi

kvm · raspberry

November 7, 2021 at 11:54:12 AM GMT+1 * · permalink

https://github.com/pikvm/pikvm

PostgreSQL 14’s enable_memoize For Improved Performance of Nested Loop Joins – Java, SQL and jOOQ.

PostgreSQL · memoize · pg14

November 5, 2021 at 8:04:13 PM GMT+1 * · permalink

https://blog.jooq.org/postgresql-14s-enable_memoize-for-improved-performance-of-nested-loop-joins/

Using LVM cache for storage tiering - Luc de Louw's Blog

LVM · Cache

November 1, 2021 at 9:08:09 AM GMT+1 * · permalink

https://blog.delouw.ch/2020/01/29/using-lvm-cache-for-storage-tiering/

More robust collations with ICU support in PostgreSQL 10 - 2ndQuadrant | PostgreSQL

ICU · PostgreSQL · Collation

October 29, 2021 at 5:15:01 PM GMT+2 * · permalink

https://www.2ndquadrant.com/en/blog/icu-support-postgresql-10/

GitHub - enova/pgl_ddl_deploy: Transparent Logical DDL Replication

PostgreSQL · logique · Replication · DDL

October 29, 2021 at 2:20:31 PM GMT+2 * · permalink

https://github.com/enova/pgl_ddl_deploy

Choice of Table Column Types and Order When Migrating to PostgreSQL

PostgreSQL · Internal · types · alignement

October 28, 2021 at 3:29:09 PM GMT+2 * · permalink

https://blog.crunchydata.com/blog/choice-of-table-column-types-and-order-when-migrating-to-postgresql

Les phoques au secours des baleines - À la découverte de Podman (Benjamin Vouillaume) - YouTube

podman · Docker

October 28, 2021 at 12:30:09 PM GMT+2 * · permalink

https://www.youtube.com/watch?v=pUFIG2AMDhg

А deep dive into PostgreSQL query optimizations : Postgres Professional

PostgreSQL · not_read · SQL · tuning

October 27, 2021 at 11:59:04 AM GMT+2 * · permalink

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

TCP keepalive for a better PostgreSQL experience - CYBERTEC

PostgreSQL · Network · TCP · keepalive · pg14

October 27, 2021 at 11:22:32 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/tcp-keepalive-for-a-better-postgresql-experience/

Database Security Best Practices on Kubernetes

PostgreSQL · Kubernetes · Security

October 26, 2021 at 11:07:54 PM GMT+2 * · permalink

https://blog.crunchydata.com/blog/database-security-best-practices-on-kubernetes

GitHub - huachaohuang/awesome-dbdev: Awesome materials about database development.

database · Research · not_read

October 25, 2021 at 12:40:30 PM GMT+2 * · permalink

https://github.com/huachaohuang/awesome-dbdev

GitHub - yingjunwu/DBMS-Indexology: A Collection of Papers on Database Index Structures

database · Research · index

October 25, 2021 at 12:39:45 PM GMT+2 * · permalink

https://github.com/yingjunwu/DBMS-Indexology

Strings, arrays, recursion, and parsing JSON: Exploring PL/pgSQL | notes.eatonphil.com

PostgreSQL · plpgsql

October 24, 2021 at 8:25:24 PM GMT+2 * · permalink

https://notes.eatonphil.com/exploring-plpgsql.html

Postgres text search: balancing query time and relevancy

PostgreSQL · FTS · trgm · rank

October 21, 2021 at 12:02:32 PM GMT+2 * · permalink

https://about.sourcegraph.com/blog/postgres-text-search-balancing-query-time-and-relevancy/

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance | Haki Benita

PostgreSQL · toast

October 21, 2021 at 11:17:45 AM GMT+2 * · permalink

https://hakibenita.com/sql-medium-text-performance