Define not used DB indexes in PostgreSQL 2024-02-03 0 70 Mano blog 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 remove those indexes. SELECT pg_size_pretty(pg_rela... db postgresql Read more
CTE block will make your code clear and readable 2024-02-01 0 89 Mano blog If you want to make your SQL readable and solve many performance questions first of all create CTE blocks. This simple and understandable solution solve for you many problems. But for better performan... SQL db mysql oracle postgresql Read more
Data modeling rules 2024-02-01 0 77 Mano blog Objects (main part): All public relations, schemas, i.e. PostgreSQL has public schema and a postgres user, also public rights must be deleted. All xxx_log tables have to be put to "log" schema. All ad... db postgresql Read more