InvolutionI watched an interesting video that accidentally entered my information bubble — a story about a trend in Asian society called…Jul 4, 2024Jul 4, 2024
Does Query ID technology give PostgreSQL developers a tool to use ML methods in DBMS management?How many of you have tried using a machine-learning approach to self-manage DBMS instances?Jan 28, 2024Jan 28, 2024
Too simplistic strategy of picking suitable index in PostgreSQLWhen PostgreSQL chooses the index to scan, it leans only on the cardinality of source, result set and the cost of scanning. Sometimes, it…Sep 17, 2023Sep 17, 2023
Как я съездил в Куала-Лумпур за туристической визой Тайланда(по состоянию на 30 августа 2023 г.)Sep 1, 2023Sep 1, 2023
Денежный перевод из БКС в Австралийский банк — август 2023Финансовые правила для тех, кто имеет Российский паспорт и никакого ID в другой стране, постоянно меняются. Однако жить как-то надо, и…Aug 19, 2023Aug 19, 2023
PostgreSQL: one experiment on comparison of MergeJoin, HashJoin and NestLoopDiscovering data skew and behaviour of the PostgreSQL optimizer, I found strange EXPLAINs. Just look at this. Here is a simple query:Aug 18, 2023Aug 18, 2023
PostgreSQL: how to do sharding effectivelySometimes we want to distribute large tables from local database across several instances. Currently PostgreSQL provides partitioning for…Apr 17, 2020A response icon1Apr 17, 2020A response icon1
Can I use Raspberry Pi4 for PostgreSQL development?It is interesting, can we use so small and quiet device to code and test postgresql.Apr 12, 2020Apr 12, 2020