I
I
ivprokofyev2020-10-25 11:38:30
HTML
ivprokofyev, 2020-10-25 11:38:30

Why feeds query performance to PostgreSQL?

Couldn't find a solution. Why does the performance of executing queries in the database decrease with the time the server is running? What to look for and where to look first? The problem is solved only after reboot of the server.

One and the same transaction fulfills from 30 seconds (after a long server operation) to 3 seconds (after a reboot). Below is an example:
Before reboot:
5f953952889b6858878892.png
After reboot:
5f9539712e5f4920775073.png

Answer the question

In order to leave comments, you need to log in

6 answer(s)
S
sergey, 2016-04-19
@zorro76

To all of the above, I’ll add assets.adobe , a very convenient tool for a layout designer, moreover, layering, description of css styles, site colors, sizes, fonts, working with svg and saving img directly to the project. Very convenient and practical and free, get an Adobe ID and use it.

A
Andrey Andreev, 2016-04-19
@b0nn1e

If you only need for layout, then it is ideal for you - https://avocode.com/

D
Denis Ineshin, 2016-04-19
@IonDen

Why no photoshop? Photoshop is not expensive now: for example, a subscription for photographers is 299 rubles / month

A
Archer *range attack +10*, 2016-04-20
@kon-rafikov

There is a build of GIMP called GIMPshop. If, in addition to the interface, they have also worked on something, then it can be considered as an option.

W
web11, 2016-04-28
@web11

Editor from Adobe brackets.io Allows you to open psd, view layers, copy styles from the document directly.

K
ky0, 2020-10-25
@ky0

Settings related to memory, buffers and I / O - to the studio. What else is on the server, except for the DBMS?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question