Mano Blog

Get in touch with me

Define not used DB indexes
How to know which DB indexes are not used? For PostgreSQL is simple, use the following query to find not used indexes. After analyze don't forget to...
Pavel Vrublevskij, Pavel Vrublevskij
— May 2019 — 953 views Postgresql

CTE block will make your code clear
If you want to make your SQL readable and solve many performance questions first of all create CTE blocks. This simple and understandable solution s...
Pavel Vrublevskij, Pavel Vrublevskij
— February 2019 — 1058 views Postgresql SQL

Data modeling rules
* * Objects (main part):* All public relations, schemas, i.e. PostgreSQL has public schema and a postgres user, also public rights must be deleted. ...
Pavel Vrublevskij, Pavel Vrublevskij
— January 2019 — 1096 views Postgresql

Pavel Vrublevskij

IT sferos specialistas, verslo sistemų kūrėjas, programuotojas (JAVA, PHP, Object Pascal ir kt.), duomenų bazių žinovas (PostgreSQL, Sybase, DB2 ir kt.), mokytojas - mentorius, IT dizaineris.

Esu GitHub'e

Sekti atnaujinimus :

Participate on our social stream.

Mano dienoraščiai

Tags

Archives