Define not used DB indexes in PostgreSQL 2024-02-03 0 70 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
Reasons why you may choose to split your environment 2024-02-03 0 90 First, ask for yourself a questions: In multi-user environment, how exactly would you manage concurrent users? Will they take turns? Will they use terminal to log in? One client could potentially brin... architecture infrastructure Read more
CTE block will make your code clear and readable 2024-02-01 0 89 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 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