Postgres auto_explain: request plan autogas

Postgres auto_explain: request plan autogasVery briefly I will show how to configure PG to log query plans and how then, do not search the logs for everything that was slowly executed by
 
auto_explain
 
The auto_explain module provides the ability to automatically log plans for executing slow operators, which allows you to do without running EXPLAIN manually. This is especially useful for identifying unoptimized queries in large applications.
 
Those. in Postgres it is possible to learn the plan of the request at the moment of its execution
 
 
This can be done in two ways:
 
 
Enabling the module for the query:
...
+ 0 -

Virtual server with extreme performance

Virtual server with extreme performance  
 
Since yesterday we have added absolutely new and unique equipment in the market of cloud services - you will not find such VPS /VDS from any provider:
 
 
 
The newest processors are Intel Xeon W-2145 with a clock speed of 3.7GHz, and thanks to a powerful liquid cooling system they work with us almost all the time at a frequency of 4.4 GHz
 
RAM is the fastest of all existing server variants with a frequency of 2666MHz
 
Disk system - one of the most reliable and fast RAID? built on the latest Broadcom MegaRAID (ex LSI) controllers and disks. SSD PCIe NVMe enterprise-class Intel ...
+ 0 -

JavaScript ES6: write less - do more

JavaScript ES6: write less - do moreThe ES6 standard brought new syntactic constructions and remarkable features to the world of jаvascript development, which, among other things, improve the readability of program texts, allow them to be concise and more expressive. All this allows the developer to solve the same tasks as before, writing less code. "Writing less - doing more" is an idea that inspired the author of the material, the translation of which we are publishing today, to explore the possibilities of ES6. In particular, here he compares ES5 and ES6 and considers options for the practical use of new designs.
 
 
...
+ 0 -

The loud sound of the fire extinguishing system disables the drives in the Nasdaq

The loud sound of the fire extinguishing system disables the drives in the Nasdaqdata center.   In the Swedish data center Digiplex, which is used by Nasdaq for operations in Northern Europe, a serious malfunction occurred in mid-April. Hard drives of many servers have failed. The cause was an incorrectly tuned firefighting system - it issued an extremely loud sound during operation, which caused damage to the discs.   What happened  Traditionally, I use data centers and technical rooms using extinguishing systems that work with inert gas - this allows you to extinguish a fire without damaging the equipment with water or foam. However, if the system is incorrectly configured, its operation ...
+ 0 -

Plausible reconstruction of Instagram-like filters

Plausible reconstruction of Instagram-like filtersThere is a bunch of software that allows users to apply different color filters to their photos. The pioneer in this case was Instagram and sometimes I want to make filters familiar to users in my application. And I want to present a set of utilities that will allow very accurately reproduce color filters from other applications in your application in semi-automatic mode.
 
https://github.com/homm/color-filters-reconstruction
 
People like the filters from Instagram. They are trying play their ...
+ 0 -

(Laws of Akin) laws of space engineering

1. Engineering development is figures. Analysis without numbers is just an opinion.
 
 
2. Creating the right rocket takes an infinite amount of time. Therefore, it is necessary to create missiles in which something is not right.
 
spacecraft.ssl.umd.edu/akins_laws.html 1. Engineering development is figures. Analysis without numbers is just an opinion.  2. Creating the right rocket takes an infinite amount of time. Therefore, it is necessary to create missiles in which something is not right.  spacecraft.ssl.umd.edu/akins_laws.html ...
+ 0 -

Digest of events for HR-specialists in IT sphere for May 2018

Digest of events for HR-specialists in IT sphere for May 2018
 
 
Despite the holidays, in May HR-specialists are waiting for a rich program of events that will help to easily solve HR-tasks: trainings, mitapas and online communication with the best specialists in the field. Follow the updates of the post, the announcements of the events for the second half of the month will be added later.
 
Details and registration
 
 
 

Conference HR API ???r3r3463.


 
When: 11-12 May, 09:00
 
Where: St. Petersburg, st. Starting, 6A
 
Terms of participation: ??? rubles for fiz. persons (2?000 rubles for legal entities)
 
Organizer: ...
[/h]
+ 0 -

How we build DevOps in a team of 125 developers

Hello.
 
 
My name is Alexander Chernikov , I am the head of development in the division "Digital Corporate Bank" of Sberbank and Sberteha.
 
 
I'll tell you today about DevOps in Sberbank Business Online (SBBOL), which we built in a big team (125 developers) with a great Review (75 PRs per day). Now the debugged CD (CI) process for pull-requests (hereinafter PR) is an integral part of the job and our pride.
 
 
How we build DevOps in a team of 125 developers  
plugin . Those. he every 15 minutes (cron) bypassed PR with new comments test this please ...
+ 0 -

Administrative hysteria

- No, colleagues, it's not going to work! From this day we introduce a new order of meetings, reporting and management. Otherwise our company at full speed will please the abyss. Such situations as last week are unacceptable! This is mine, and your fault. I do not take responsibility with myself, and I strongly recommend that you do not, I do not recommend it, but I order you to immediately change your attitude towards your job duties! You are leaders, not linear performers!
 
 
There was an awkward pause in the meeting room. No one was looking at the director - this is fraught with sudden attention ...
+ 0 -

We apply a gradient descent on the real Earth

We apply a gradient descent on the real EarthThe usual analogy for the explanation is gradient descent such: the person has got stuck in mountains during a strong fog and should go down downwards. The most logical way is to inspect the surface around and slowly pave the way, following down the slope.
 
 
This is the essence of the gradient descent, but the analogy always falls apart when we go into a multidimensional space whose actual geometry is little known to us. Although usually this does not become a problem, because the gradient descent seems to work quite normally.
 
 
But here is an important question: how well gradient descent ...
+ 0 -