Mano blog | asprogramuoju

Mano blog

We are a team of passionate people whose goal is to improve everyone's life.

Define not used DB indexes in PostgreSQL

2024-02-03

0 287

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

Reasons why you may choose to split your environment

2024-02-03

0 709

Mano blog

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

CTE block will make your code clear and readable

2024-02-02

0 375

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

Data modeling rules

2024-02-02

0 403

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

Apie Skyrelį

Tai kas naudinga ir aktualu.

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

Archyvai

Žymos

architecture db infrastructure mysql oracle postgresql SQL