Coordinator of the development of PostgreSQL will visit Moscow

Bruce and elephants
The company the organizers of the conference Highload-2007 are pleased to announce that in late September, will visit Moscow one of founders and active member of the PostgreSQL Core Team Bruce Momjian (Bruce Momjian). Bruce will speak at the conference and will hold a 4-hour training:

"performance Improvements, PostgreSQL 8.3"
Bruce Momjian report

PostgreSQL is a freely distributed object-relational database management system, the most developed from open DBMS in the world and is a real alternative to commercial databases. Each new version of PostgreSQL is a major step forward thanks to new unique features and optimize existing ones. Particular attention in the development of the system of paid productivity.

This report will describe the non-trivial steps to optimize performance of PostgreSQL 8.3. Bruce Momjian describe the implementation details of these changes and explain how and to what extent users of PostgreSQL can benefit from these improvements. In addition, the list of other innovations expected in version 8.3.

the "PostgreSQL performance tuning"
Bruce Momjian training

This workshop is designed for users of PostgreSQL who wish to obtain advanced knowledge for performance tuning PostgreSQL. Will cover all aspects performance:

* server settings
* caching,
* resource management operating systems
* work on the optimizer
* problematic queries,
* the effectiveness of storage
* some details of the choice of iron.

Attendees will learn how to properly dispose of shared memory, learn to understand the data provided by the optimizer, and how to configure storage for optimal performance.

About the author of training: Bruce Momjian is a co-founder and active member of the PostgreSQL Global Development Group, among its main duties is the coordination of the development process, processing and acceptance of patches, supports TODO list, training. Through communication with the key developers of PostgreSQL, participants will be able to strengthen and significantly expand their knowledge and skills in optimizing system performance.


In addition, Highload-2007 on the issues of system performance create generic GiST and GIN indexes will tell Fedor Sigaev, one of the key developers of PostgreSQL.
Article based on information from habrahabr.ru

Comments

Post a Comment

Popular posts from this blog

Powershell and Cyrillic in the console (updated)

Image
In the development process is very often necessary to run a powershell script from a console application. What could be easier? the #test.ps1 & $PSScriptRoot\ConsoleApp.exe Examine the behavior of console applications when running them from the command line, using PowerShell and using PowerShell ISE: execution Result In PowerShell ISE, there is a problem with encoding, as the ISE expects the output to the encoding 1251. Use Google and find two problem solving: c use [Console]::OutputEncoding and through the powershell pipeline. Let's use the first solution: test2.ps1 $ErrorActionPreference = "Stop" function RunConsole($scriptBlock) { $encoding = [Console]::OutputEncoding [Console]::OutputEncoding = [System.Text.Encoding]::GetEncoding("cp866") try { &$scriptBlock } finally { [Console]::OutputEncoding = $encoding } } RunConsole { & $PSScriptRoot\ConsoleApp1.exe } execution Result At the command prompt, all is well, bu
Read more

Active/Passive PostgreSQL Cluster, using Pacemaker, Corosync

Image
Description This article describes an example of configuring Active/Passive PostgreSQL cluster, using Pacemaker, Corosync. As the disk subsystem is considered the drive from the system data storage (CSV). Similar to the Windows Failover Cluster from Microsoft. Technical details: OS Version — CentOS 7.1 Version package pacemaker — 1.1.13-10 Package version pcs — 0.9.143 PostgreSQL — 9.4.6 As servers(2pcs) — iron server 2*12 CPU/ memory 94GB As a CSV(Cluster Shared Volume) — an array of class Mid-Range Hitachi RAID 1+0 Preparation of cluster nodes Rule /etc/hosts on both hosts and make the visibility of hosts to each other by short names, for example: the [root@node1 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 10.1.66.23 node1.local.lan node1 10.1.66.24 node2.local.lan node2 Also make exchange between servers using SSH keys and
Read more

Automatic deployment ElasticBeanstalk using Bitbucket Pipelines

Image
bitbucket is a service ( Bitbucket Pipelines), which among other things allows extremely simple to automate the deployment of applications in the Amazon cloud, in particular using ElasticBeanstallk. To whom interesting, I ask under kat. the Prerequirements You should already be created ElasticBeanstalk application and deployed environments (in order to do this, refer to the official AWS documentation for, so, for example, unfolds Django ). Since the service is still undergoing testing, you need to request access to it here . the project setup Let's say we have two branches, master and we want to deplot on production environment and development — development environment. Create in the root of the project file bitbucket-pipelines.yml with the following content: the image: python:2.7.11 pipelines: branches: master: - step: script: - apt-get update # to install required zip - apt-get install -y zip # required for packaging up the application - pip install b
Read more