Improving PostgreSQL for Greater Enterprise Adoption
Formal Metadata
Title 
Improving PostgreSQL for Greater Enterprise Adoption

Title of Series  
Number of Parts 
29

Author 

Contributors 

License 
CC Attribution  ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and noncommercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this license. 
Identifiers 

Publisher 

Release Date 
2015

Language 
English

Production Place 
Ottawa, Canada

Content Metadata
Subject Area  
Abstract 
PostgreSQL Enterprise Consortium (PGECons for short) is an organization that consists of major IT companies in Japan, aiming to promote PostgreSQL to enterprise users in the country. Since 2012 when PGECons was established, we have been doing surveys of PostgreSQL's functions and performance to PGECons members to estimate how PostgreSQL well meets their requirements. In this talk, we will focus on some of major requests from the surveys, including enhancement of table partitioning and error messages handling. From the enterprise users' point of view, we would like to share these obstacles behind the requests that might limit PostgreSQL's acceptance, in order to cope with these issues with the community. [Partitioning] More the size of a database grows, the more difficult the design and operation of the system become. For example, a sales accounting application has such difficulty, which is often solved by using horizontal table partitioning. We have surveyed how PostgreSQL can be applied to such kind of applications to the member of PGECons, and evaluated performance of table partitioning. These surveys result suggested PostgreSQL partitioning issues below. larger number of partitions slows query response time definition and usage of partitioned table are intricate From additional surveys about proprietary DBMS usage to the members, we will show what are needed in partitioning and the features of the application areas that are important but difficult to be supported by PostgreSQL. Then, we will point out that enhancing partitioning functions will make PostgreSQL to be spread to the aforementioned areas. [Error messages] When shooting a trouble about PostgreSQL, a user analyzes a trouble to identify the cause based on the error logs and error messages. However, when we analyze a trouble with only SQLSTATE code we sometimes cannot identify the exact cause because an error code is often assigned to multiple different error messages. Also, we have similar difficulty when analyzing a trouble from error messages. To cope with these problems, Fujitsu Limited, a member of PGECons, delivers customers a list of error messages sorted by SQLSTATE codes to search the corrective actions. In the list, an identifier is added to each item so that customers immediately decide corrective actions and communicate smoothly with support staffs. Based on our activities above, we will propose error message systems which will bring following two merits: accelerate decisions on corrective actions enhance the self support by users In this presentation, we will show the needs and actions from members of PGECons as enterprise users, to share the way of improvement, which should help promote PostgreSQL among the community.

Related Material
00:00
Metropolitan area network
Enterprise architecture
Presentation of a group
Open source
Information
Length
Executive information system
Multiplication sign
Orientation (vector space)
Forcing (mathematics)
Electronic mailing list
Student's ttest
Open set
Mechanism design
Software
Oval
Radiofrequency identification
Information
Game theory
Form (programming)
Selforganization
01:19
Axiom of choice
Standard deviation
Functional (mathematics)
Table (information)
Computer file
Distribution (mathematics)
State of matter
Mathematical singularity
Parameter (computer programming)
Valueadded network
Area
Number
System programming
Arithmetic logic unit
Gamma function
Area
Metropolitan area network
Enterprise architecture
Inference engine
Open set
Product (business)
Inclusion map
Partition (number theory)
Software
Query language
System programming
Interpreter (computing)
Transportation theory (mathematics)
Intercept theorem
Table (information)
03:29
Point (geometry)
Metropolitan area network
Presentation of a group
Computer file
Archaeological field survey
Division (mathematics)
Basis <Mathematik>
Branch (computer science)
Mereology
Cartesian coordinate system
Disk readandwrite head
Radiofrequency identification
Personal digital assistant
Core dump
System programming
System programming
Pattern language
Software testing
05:12
Email
Group action
Momentum
Table (information)
Observational study
Open source
Multiplication sign
Source code
Maxima and minima
Time series
Mereology
Field (computer science)
Frequency
Pointer (computer programming)
Blog
Military operation
Repository (publishing)
System programming
Gamma function
Message passing
Task (computing)
Area
Metropolitan area network
Dependent and independent variables
Model theory
Physical law
Stress (mechanics)
Database
Port scanner
Timestamp
Partition (number theory)
Frequency
Personal digital assistant
Telecommunication
File archiver
Routing
08:21
Beat (acoustics)
Execution unit
Division (mathematics)
Branch (computer science)
Mereology
Theory
Number
Independence (probability theory)
Finite set
Graph (mathematics)
Partition (number theory)
Metropolitan area network
Theory of relativity
Forcing (mathematics)
Physical law
Database
Port scanner
Cartesian coordinate system
Flow separation
Vector potential
Partition (number theory)
Type theory
Data model
Query language
Personal digital assistant
Pattern language
10:25
Ocean current
Point (geometry)
Metropolitan area network
Dependent and independent variables
Physical law
Source code
Time series
Menu (computing)
Mereology
Cartesian coordinate system
Event horizon
Rule of inference
Power (physics)
Number
Partition (number theory)
Performance appraisal
Personal digital assistant
Graph (mathematics)
Videoconferencing
Video game
Summierbarkeit
Pattern language
Gamma function
Partition (number theory)
12:56
Functional (mathematics)
Group action
Table (information)
Distribution (mathematics)
Logarithm
Model theory
Multiplication sign
Mathematical singularity
Knot
Maxima and minima
Compiler
Mereology
Rule of inference
Number
Product (business)
Software bug
Performance appraisal
Componentbased software engineering
Bit rate
Insertion loss
Military operation
Operator (mathematics)
Pattern language
Metropolitan area network
Pairwise comparison
Addition
Overhead (computing)
Model theory
System call
Product (business)
Partition (number theory)
Query language
Function (mathematics)
Bellman equation
Right angle
Table (information)
15:55
Group action
Distribution (mathematics)
State of matter
Information overload
Decision theory
Multiplication sign
View (database)
Source code
Insertion loss
Icosahedron
Mereology
Storage area network
Fluid statics
Insertion loss
Hypermedia
Data acquisition
Cuboid
Partition (number theory)
Area
Metropolitan area network
Boss Corporation
Distributive property
Partition (number theory)
Type theory
Process (computing)
System identification
Software testing
Right angle
Quicksort
Curve fitting
Functional (mathematics)
Table (information)
Rule of inference
Broadcasting (networking)
Cache (computing)
Causality
Directed set
Software testing
Statement (computer science)
Implementation
Form (programming)
Task (computing)
Focus (optics)
Distribution (mathematics)
Key (cryptography)
Server (computing)
Model theory
Line (geometry)
Singleprecision floatingpoint format
Personal digital assistant
Function (mathematics)
Statement (computer science)
19:50
Point (geometry)
Metropolitan area network
Distribution (mathematics)
Functional (mathematics)
Logical constant
Distribution (mathematics)
Server (computing)
Source code
Mathematical analysis
Bit rate
Parameter (computer programming)
Port scanner
Partition (number theory)
Cache (computing)
Oval
Insertion loss
Function (mathematics)
Software testing
Directed set
Right angle
Implementation
20:30
Point (geometry)
Functional (mathematics)
Table (information)
Distribution (mathematics)
State of matter
Multiplication sign
Mathematical analysis
Bit rate
Mereology
Rule of inference
Computer programming
Number
Product (business)
Cache (computing)
Bit rate
Insertion loss
Series (mathematics)
Gamma function
Partition (number theory)
Social class
Metropolitan area network
Addition
Call centre
Logical constant
Graph (mathematics)
Port scanner
Partition (number theory)
Query language
Function (mathematics)
Software testing
Table (information)
23:08
Point (geometry)
Addition
Zoom lens
Functional (mathematics)
Table (information)
Multiplication sign
Graph (mathematics)
Maxima and minima
Set (mathematics)
Port scanner
Mereology
Cartesian coordinate system
Rule of inference
Computer programming
Valueadded network
Number
Singleprecision floatingpoint format
Partition (number theory)
Personal digital assistant
Kinematics
System programming
Figurate number
Resultant
25:02
Point (geometry)
Functional (mathematics)
Table (information)
Distribution (mathematics)
Multiplication sign
Mathematical singularity
ACID
Time series
Insertion loss
Mathematical analysis
Mereology
Performance appraisal
Cache (computing)
Insertion loss
Reduction of order
Software testing
Statement (computer science)
Implementation
Gamma function
Partition (number theory)
Metropolitan area network
Enterprise architecture
Distribution (mathematics)
Multiplication
Scaling (geometry)
Consistency
Mathematical analysis
Price index
Port scanner
Partition (number theory)
Process (computing)
Personal digital assistant
Query language
Function (mathematics)
System programming
Statement (computer science)
Pattern language
Object (grammar)
Table (information)
Bounded variation
27:38
Point (geometry)
Wechselseitige Information
Functional (mathematics)
Table (information)
Distribution (mathematics)
Multiplication sign
Range (statistics)
Water vapor
Electronic mailing list
Student's ttest
Open set
Mereology
Mechanism design
Root
Causality
Bit rate
Term (mathematics)
Authorization
Statement (computer science)
Data structure
Area
Domain name
Addition
Distribution (mathematics)
Information systems
Binary code
Distributive property
Port scanner
Binary file
Partition (number theory)
Positional notation
Function (mathematics)
Phase transition
Right angle
Table (information)
30:34
Point (geometry)
Metropolitan area network
Enterprise architecture
Confidence interval
Multiplication sign
Cellular automaton
Sampling (statistics)
Code
Database
Staff (military)
Price index
Total S.A.
Event horizon
Product (business)
Inference
Frequency
Event horizon
Bit rate
Personal digital assistant
Military operation
Operator (mathematics)
System programming
System programming
Form (programming)
33:19
State of matter
Logarithm
Multiplication sign
Execution unit
Coprocessor
Computer configuration
Military operation
Operator (mathematics)
System programming
Information
Information security
Backup
Form (programming)
Metropolitan area network
Service (economics)
Dependent and independent variables
Information
Database
Price index
System call
Inclusion map
Data mining
Causality
Shooting method
Software
Personal digital assistant
System programming
Density matrix
Identity management
35:20
Statistics
Dependent and independent variables
Interface (computing)
Graph (mathematics)
Code
Ext functor
Bit
Group action
Rule of inference
Data mining
System programming
Website
System programming
Normal (geometry)
Gamma function
Message passing
World Wide Web Consortium
36:16
Slide rule
Mathematical singularity
Execution unit
Knot
Insertion loss
Expert system
Mereology
Causality
Hypermedia
Pattern language
Software testing
Statement (computer science)
Message passing
Error message
Multiplication
World Wide Web Consortium
Server (computing)
Data recovery
Cellular automaton
Sampling (statistics)
Code
Bit
Deadlock
Frame problem
Causality
Process (computing)
Personal digital assistant
System programming
38:10
Logarithm
Mathematical singularity
Source code
Maxima and minima
Function (mathematics)
Mereology
Variable (mathematics)
Number
Pattern language
Regular expression
Fuzzy logic
Message passing
Error message
Condition number
Dataflow
Expression
Sampling (statistics)
Code
Port scanner
Category of being
Message passing
Personal digital assistant
Function (mathematics)
Mixed reality
Energy level
39:39
Point (geometry)
Open source
Logarithm
Source code
Maxima and minima
Knot
Mereology
Computer programming
Componentbased software engineering
Military operation
Operator (mathematics)
Pattern language
Regular expression
Website
Message passing
Task (computing)
Electric generator
Dataflow
Uniqueness quantification
Electronic mailing list
Shared memory
Bit
Port scanner
Group action
Causality
Message passing
Personal digital assistant
Function (mathematics)
System programming
Energy level
Ideal (ethics)
41:16
Module (mathematics)
Table (information)
Readonly memory
Personal digital assistant
Data recovery
Computer file
Client (computing)
Queue (abstract data type)
Group action
Message passing
Annihilator (ring theory)
Condition number
41:57
Point (geometry)
Weight
Line (geometry)
Multiplication sign
Source code
Bit rate
Mechanism design
Goodness of fit
Diagram
Data structure
Gamma function
Message passing
Pole (complex analysis)
Error message
Metropolitan area network
Pairwise comparison
Constraint (mathematics)
Server (computing)
Computer file
Content (media)
Code
Variance
Client (computing)
Line (geometry)
Translation (relic)
Front and back ends
Concordance (publishing)
Message passing
Film editing
Personal digital assistant
Function (mathematics)
Different (Kate Ryan album)
Social class
45:00
Point (geometry)
Dataflow
Dependent and independent variables
Logarithm
Source code
Knot
Expandierender Graph
Evolute
Valueadded network
Causality
Military operation
String (computer science)
Time evolution
Graph (mathematics)
Software
System programming
Message passing
Directed graph
Data type
00:01
FIL OK it's time for presentation OK at in this speaks to a list of speaking thinking of oriented and then demand and my name is it's a about from NTT Japan today we'll talk about improving people's lives to the full breadth of enterprise some of them
00:26
being fool we mine and that's a 2nd time time i've got 4 I for in the the open source software and are watching these forces Q for about 3 years and this these year in a lot of time to mark for for the student to cooperation we are the men of both what is secure enterprise called since it is now mechanism that consists of all the IT companies in Japan alright for the food and people in the city is analyzed some form or companies 16 the general information you can get here and this is the from work we have already game of talk in physical 2013
01:20
so all of before talking about people are introduced the situation both what is carrying Japan briefly in about was this is all right to interpret systems by the 2 on it or state was of use of credit to the inference system all enterprise and now it is up prior to the enterprise mission critical systems him according to to the influence of the clues Sunday they provide about from southern systems based on book with the choices of this with the software interceptions company so the taking of such of advantageous all I know how about the mission critical systems our was the political social and at was so Shomu they need more of that so I'll post was created to interpret system today we
02:34
talked about 2 topics based on local social activities with some areas of functionality and performance and go for missioncritical systems Mr. area on the file and therefore all the items to be improved why functioning facilities of the performance of queries on partitioning table is not enough to handle many number about so once suggested 100 and the 2nd 1 is facilities for from shooting this area talked about in what some you of stuff that the Apollo of scenario is shows that argument about this it will be something and according to thank you all other mentioned people
03:37
I talked for I talked with both of the skin for many of us right we have talked about it is possible to secure our customers sometimes called brains but in this case not good but it's our parts and facilities of basis so gratified post minuscule so clarify but showing issues we studied its usage and there 2 1 is the rise a lot that people use these buttons on the cases partitioning the 2nd point is what do quite yet to partitioning the test and so on a really we did was more stubbornly by showing to what we be interpret member of 1 in this southern at most of systems are intended to always keep the oriented competencies the applications but of course there are many always AB applications and that all of the case of a dump of the file is going to and we found to keep going up and down and all that you a parts in a nuisance why eroding patterns in data onto to a that the divided into branches on things point and a head full of foods is our presentation the 1st part of
05:14
the the data that we forms of many of the riser databases the start time series data you with data I could write rules but in the databases rooted in some of these continuous and after the Roman data as of aggregating continuously for example 1 study week or once a month and so on and finally I know momentum describe the opportunity for example once a year and song on certain cases found where we can see that 2 cases of why is it that you have to communicate area of model fits into the open source of stress and it's narrator about onethird all all companies system with operating around this other of both the spirit of the course is a member of course of pointed out such a part time is over and seeing the research on the financial systems the goal of the system has to be handled and much this and the data it is possible that were created in the country on this and as tasks are some of you may archival system and that's to be answer the damn it starts in the initial time to do so to response for the purpose the next I will
07:03
talk about this but in detail the role of data that are I was continuously changes a ruled it out of continuously to the database is on the on this side of the city do it is to partitioning according to the time stamps for example and it allows the 288 dual but they start this year and in nineties know she handle all the way over here data enough specific parts of the source this period we have only 2 routes there not particularly parts you and not told that the role of law along the actions of example we sum up at the top of the we only have to take this part so what is so and so on when describing the data at all we only have to truncate parts on during the things all of we we can discover data field that I and on with this pair of actually mean tables after and that's the part
08:23
on tools because the proton . name names data divided into branches of database I the finite set of potential slow data partitions each that's laws of data they got done related to what brands to well brands only and the number of of is about 1 thousand of course it depends on the number of branches of Bank has I think it was in this case the 2 branches can be handled well or can be queried independently of course there's several queries over the data for additional uh that just the data and that's just the type of from minis for many parts of so
09:24
according to our small salary costs relation with the patterns used is as at 1st of all as data the size of that of that is how the data 1 terabytes of quality of fighting forces on a particular application on them before this guy is the propagation and in the in the intensity of the data divided into the brand divided into and the next question is what kind of query is used frequently in most of queries so that only 1 part of it to look up data or other units all of course on the other hand the standard theory every year it's data model among participants to me what joint top beating partitions not only now you we
10:32
have depicted depicted in this situation where collection used very rich think about the menu planner for much of that 1st number of participants in the physical areas of about 1 so that the participants on its own we thought we think along southern parts is enough to know it is not always enough such sent for men most applications for unintelligible uh being looking time series data and if we want that so for today and we'll have to study at the full 3 hours up among the points and that was 1 of but the next and then next government is speeding up the evocation is to find out if the initial and credit to and 2nd of this vesicle and part crystal courses so it's a kind requirement for parts of what kind of possibilities use of them as far as we know all the rent cancel on the response for a really intense in that case apart song is divided into 2 parts of this part rule under divided that by such a brontosaurus to so we use these the parts they found applications and markets require a source of some public going out of much current policies for example the data into divided the grantees on these events of data that is divided by time series you buy this part when you have the highest partitioning is fair about news as far as we know the sum of squared . uncertain what lots of but of 1 of our founding the smartest lose some new patterns of videos of power you know the laws that size is about from the 10 year bond to 100 in your life so we
13:00
call gratified tuition was on the continent of constant then well we've done right to know its performance issues opposed risk going up also some evaluated the performance of parts and you old you times that the more of a lot of you go see the park to provide performance each but we use various number of participants to know all of slowing it down according but past will buy this these numbers are so 90 shifted by and simultaneously the we tested various missiles to distributed data to parts of and to know the all of all all by the parts the missile that the study of functional and then conditional on the functional component from function using the origins of the letter that 50 indeed a rates
14:11
not yeah this thing all various some more at 1st but there isn't but eyes are routinely dancers data in this model we go data from a group called products and there is that they are struggling to table continuously broke the rules I I on day stood on function the table apart so is for the value for all data are in food is what's shown is that it is better data for that arrive the 68 and you find this in 90 to engine and so on and then dust storm for long 3 or 6 months they are fairly the 9 people wanted a key parts on a new that and diversity scenarios we have to tuition worries data logging audit pesos additional use policy functions for data being distributional values as they are implemented full of functional for performance comparison of the current anomalies didn't give the query is president of the lower recall the performance for months the next operators for granted them indeed this is a
15:56
model of the data showed thank the model but there is 108 diaries fatigue cases along of the cases all depends on this this case a case of consolidated because in 92 so inside the 90 on 180 data under the distribution with of affiliated is the reason this filter is used and there's a lot of body size and time for the same data into a single parts of so if you feel betrayed focal point was 3 different views on the that is of forms the 1st line is static decision function that state of the art by a bunch of all hard the coded is then Bruce and for each partition if it is suitable to store the data the 2nd 1 is dynamic decision function that creates an insert a statement for falls them as sort of apart so based on the part based on the parts of key keep included in the in the in the someone is functionally different this career is that the statement right cause dynamic functions and the use these accused the prime over the sources statement on this is is this is implemented in C run this to is trying to stretch of media is the identification of here
17:48
is summary that all of the data tastes this is that the time that he does rule by a small group but is a time for certain parts of and regular the 19 parts of the chlorines is for why 180 I'm about to go of boxes that shows on you at the time for the size of the 2 of us all the time and this right so 24 also what you want on the political souls type of distribution function of this city boss flows fatigue they are full dynamics and their full broadcast under finally the right kind most once for time directly from the very 1st and the also time for data size of the longest aligned with the function of the 2nd longest aligned and from own and kept in the area of the distribution function is from just perform the other it is yeah it is the 1st time how about static functional of very very slow and prohibitively slow so we we get about 15 useful 180 days and sold you dynamic function of it that was that he wants and it is not easy to implement on is Brian task it's very fast but it is difficult to implement all of it is because the more therefore flowing and if there is a lot of that would cause us of a process so that is what you meant to so it can be difficult to test what is the important test we
19:58
talked about this OK so the
20:06
final point of the final point I found a function only of parameters is very fast about the destruction of improvement of that source of possible rescuers should be up provides a fast and people would you don't have to wait for data distribution which is you cry out of we'll repeat this point right on
20:35
to put to predictable series can performance all 4 of them in number of our participants were on the rise of the size of time with a 4 . 2 4 what parts and we compare 2 missiles occipital spread functions these you got the 2 reasons in time to for a few months of going this so these of proper into partitions in almost a call center I will concentrate on what we think why the number of parts and tents this graph so what kind of like the souls of the Argentine forwards the point of excessive so a number parts of is there and it was all about how it is there that decides on new class called course time of you got this number of politicians the dynamic functional that this is so solely right of that so the Stroop brought rules of Rudy of number of points along is the is fundable parts so increased and this might be our rate and program so if we have to arise in the politicians and
22:05
next with the cobalt states addition we use a query for reducing the this that scheme of that the schema so that discussed earlier called on you report although recall announced this violence and aggregate them by after that the idea and they are called we hope here we introduce this schema we use them to take over the worries existed over a table ofloxacin all think that these pilots and being the number of suck the 90 on the 80 and the other is to look still must and the state of a of a connected via product i.e. from access through to lose it could prevent some of the the
23:14
salt with we tested the criti again society 90 online functions and that this thing that results of but in this case also on the west so we tested but it isn't going to be really you find some kind all of them as of warrant is in the system of this is indicated in world that they but become a scanner red and orange figures scam and this graph shows of low results America's to predict going to predict
24:00
and additional performance for residents parts since all we underwriters of recent times by a recent times rules are garrison on both parts to know that grows with current realities of the activity up to time we thought the parts of the immunity from being the to the this point by the axis missile In the result is shown here the kinetics is so that you have some time to there exists a soldier noble parts come from this we know that in times of plenty of time seek a set books is where 0 and by increases of the number of points on the increase of this might be a right program for I was noble parts of that are that
25:04
are summarized the deliberations traveling to the whole was a variation of that simulates through the time of day time series data affricate 0 it is widely used in enterprise of was to the data and so and test data size would just be the by distribution functional with Denecke so that the dynamic insert statement reasons why using trying up with these functions we estimated about 200 patterns can be useful for consistency however from the viewpoint over repeat phone in the case of according to various enforcing the data distribution this use missiles acidic functional in the easiest to implement highlighted based and the other 2 methods are effective at 2 processes trade or about it is and want so it is not difficult to to implement on this on this
26:33
really summarizes data recent test we evaluated the data reduce on its speed for the data that follows from 80 patterns was to the status of both of both career objects data from the doctor enough quickly and then we predicted also reduced during the performance for more intelligence based on the data of pots and scale of this brief analysis souls the last goodies ideas resin all points on the take much attack according to sharing to of course was a member of queries I ideas that table time while parts parts of multiple partitions for example or half for a hundred generative ecuted quickly on this case and just so that we need to improve branding and indications such of course for finally body
27:41
appointed of overeating solutions of course Inc of course I mean they to decide due to diffusion on which are kind although expect it's oppressive sentence I mean easier diffusion all parts of the design of for example and this get this taken into for parts and the parts shown diffusion that and that mechanism this bond should be all too much going on there is range of the is the in use popularity so they should be defined and US Open additional for water rising and all points of is required by the area of we we directed hand to 1000 southern passions for so long term of diffusion for 1 southern parts in a few right we use these ideas for example are responsible on intensities domain John defined politicians for days months and sold by simple syntax wrist about so only given table China and the roots so disposal on a given table possibly a student can handle some time defining our parts and for each of those of the next and
29:13
then point out of rating solutions for creating a situation but 1st of in the data distribution but it's worth it is by no on user defined to functions to distributed data to parts of it are about that apart so function should be getting authority and the the and it is desirable speeding up binary search for interesting about creepresistant great for Table 2 huzzah and boats causes was noble politicians should be executive more effective are assumed to be adjusted addition official looking up apart for you will fall the value of a should be boxer writing this be Dorotea if we hire butene it structure built in data structure on this phase of this is that our this is of vital this little movement you know what
30:45
the described is more of a tax on 1 of the things the work of the form that the use of my time we to use the real thing so the following ratings from him as an adult covers the I improving new inequality so that it provides a database products based on possibility fall enterprise so today I to introduce our and politics and the proposal for the future the
32:00
1st of this thing to what needs to fall in simply because he spent so we have c . so fast point it's nonstop so to blood big dummies cell and the social arriving the was so we must not stop so our inference inference too much the system so sit on the point is to be so if the system failed so in that case so financed out of the house they began venues and so I may and new z confidence set of in our in our work I think in the case of our company so our public support the people also need to master and to their customer so leading to or was a staff fear our system and in fact going to them is a scalable operation so it is a 6 hour of enabling user indices event counts so of course also thinking for 7 sample to include in these 3 points is needed yeah
33:21
when that units nonstop so I've been debating is important and you for speedy Alfalex humans a speedy so responsibility in this case cell phone calls and so you shall are important and they're full of steerable operation so it is important to always monitored the performance and the database state to upload the system fail so the cost so not only possible next it the sheriff and but and being software and its our where support for these 3 . so we think it's insane to corroborate with the possibility yeah and this being the software to do so we think was this general hides the significant role to corroborate reasoning could itself to aware so we can give
34:22
the bias information from the possibility use how so for example soulful I money coming so we need to check that that proves processor mining and instead this forms and so forth this possible indication for and so use of so we need to analyze the deep they're all animals so false parable operation so we need to see because they're not density states and in their sponsors time steps yeah so smoke grading and old but you also need to take acts of oxysterols false security so when food of film where options 2 weeks database so today I especially for on as quick tour of Bruce shooting using an hour
35:22
so badly so this graph so so that this can that by people set up to describe the other to add up to form is simply to guide the setting a bombing people also wanted to responsible support to useful in missioncritical systems from
35:39
a muscle people ask is there additional questions so how you solve the when system will enable them so this graph shows the interface of the system using the norm possibility here so including command several them so all rules users so not all and we call for the support of this so but such such as on website of mine yeah and misstated correction bits for troubleshooting by an MSA statist of intimacy ID so for Jim said so on the other hand
36:19
so regarding the possibility to get and so advertiser heightened and see all the Interbase data shown by the error message data so let me start seeing had this to you some procedure and because we don't get too many shared and all of the loss lives side so much so it would be a bit that do not reject it so also we step so you some by grant for this so if there is a significant point but as that 2 issues so as a test I'm doing identified the cause and the and it is possible to year ended experience and media so I mean because frame that details so the next slide so I'm leading to
37:11
the users like experiences so in the case of regret called by an article so much and I'm missing these are signing to allow ample and so far for example so for the sample so an apple indicating to the end of the fifties so as it existed to process of cells called the because so it is different so you so for each part down so you then need to take a mineral solution so it did you got for unit so also there was a 120 error message so not assigned to each end up with about so that really not that this is at 21 . 97 abundant in . 9 Isely's by the 9 . 2
38:12
and in that case so this is the output by MSA sticky so that 1981 Mrs. but done so that that out to the same in March boost solves the source code so full 1 message so the marks and number of so schools so 50 fall to and numeric is included in the body of a number of message to it gives need to narrow the site and by far the conditions and they come from the monstrous so scores
38:57
also I I I I mean it introduces the difficulty all possible general so many so all wrong message at out to to 1 0 5 so it is not to be able to do this in logan at and by an island of category so for the sample so it's error probably I allowable and the slope played all so is the mix and the scrapping of the summary it is not a reduced specifies a deep their condition and and went down by the part number all the religion of expression to
39:40
hostilities late in the case all using the data bits of open source so we can get serious in our lives so as I said fine fate so by the program much but that kept much but it is the ability to text the significant considerably
40:04
so there's some genes so these so we think that there are 3 points for yeah operation as of longer messages so 1st point the disgruntled message ID and it is true best exact that generation part is understood as a component of the all of the source and improvement of the detection task in operation so money does biochemical separate them out the 2nd point uniqueness so hard to grant all the missing the ideas that have long calls so long message ID is not this and this so we also think that the considering over the detailed list is suggesting the standpoint the accumulation of knowhow so alleviation all this promise to be known as the sharing of buying misstated collection built a website so this
41:18
terrorist shows crests case example of conditions so there's there's use optional so from the 1st year that is scarce data and it I was already known performance tuning England iTunes tuning the point so that it is possible get and the that they these are our classification example FIL or we
41:51
also understand so some of the Christian faith idea so the next so
42:00
I constraints of our region to grant the message ideas 2 possible so we use a method to cut up and we support to message cut of structure of so like the Paul flies and the another line is that this time so that could the threaten mechanism in the divine the be doing some of our and the kind of crime and to derive the bad this left Kriya had example good at airport so in our experiences so i so that there are some difficulties so I I we have because we experienced so for example the so because and they are missing and grant this so long accorded and so this much to be doing best use data on the so kind of error so so we need to add the abuse so in time and so room In the case of the 9 . 2 so we have like experience so I thought was so that the 100 messages and this is similar and then they said he say that not to create content of the and it's so and support the sole monarchy 98 so we need to recreate that Mrs. cut the so called diagram 1978 very messy so next to
43:49
so I will explain hot demanding so makes idea lampless this fear is upgrading the because we have already noted in a message ID so we need to maintain by or it's not being a possibility upgrading the mother of all the places so fast point is a week of death that because the optimistic variance and the kind of generate them mechanical called concordant concordancer may based there and the book cover only so sick of point so I had that have so that the same idea or a new ideas so according to the current during the so called coordinatively so we call so he didn't have much their according to to the fact that the story could and comparison so many that is hardly so influence acyl land missing out that it's it is changing source code for so called religion
45:02
so that's so as to miss out on the 9th and by missing idea so that's FIL so we
45:17
engage so 5 up the get evolution so 3 points so that's always
45:27
source sink is very much in a truth