Andrey LepikhovInvolutionI watched an interesting video that accidentally entered my information bubble — a story about a trend in Asian society called…Jul 4Jul 4
Andrey LepikhovDoes 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 28Jan 28
Andrey LepikhovToo 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
Andrey LepikhovКак я съездил в Куала-Лумпур за туристической визой Тайланда(по состоянию на 30 августа 2023 г.)Sep 1, 2023Sep 1, 2023
Andrey LepikhovДенежный перевод из БКС в Австралийский банк — август 2023Финансовые правила для тех, кто имеет Российский паспорт и никакого ID в другой стране, постоянно меняются. Однако жить как-то надо, и…Aug 19, 2023Aug 19, 2023
Andrey LepikhovPostgreSQL: 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
Andrey LepikhovPostgreSQL: how to do sharding effectivelySometimes we want to distribute large tables from local database across several instances. Currently PostgreSQL provides partitioning for…Apr 17, 20201Apr 17, 20201
Andrey LepikhovCan 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