Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
K
K
keyotor2021-08-18 23:11:00
PostgreSQL
keyotor, 2021-08-18 23:11:00

What factors slow down a database?

Can you please tell me what factors can affect the slowdown of the database? I would like to know about postgresql

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Report
I
Ilya, 2021-08-19
@sarapinit

Indexes, triggers slow down the insertion.
Lack of indexes slows down reading.

Report
I
idShura, 2021-08-19
@idShura

DBA main factor)

Similar questions
L
Ler Den2018-04-30 15:42:17
What is the best way to speed up the selection with pagination? 2Reply
B
BestJS2018-05-03 23:26:39
How to make fast unique fetch from postgresql? 2Reply
G
Gimir2018-05-04 11:30:36
How to add variable to SQL query with "WHERE something LIKE" in Python? 0Reply
P
Pavel2015-12-25 11:06:34
How to set up a cmake project in QtCreator to work with postgres *.pgc files? 1Reply
N
Nikolai Savelyev2018-05-06 14:46:45
How to make a partial copy of a postgres database? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question