Merken

Improving PostgreSQL for Greater Enterprise Adoption

Zitierlink des Filmsegments
Embed Code

Automatisierte Medienanalyse

Beta
Erkannte Entitäten
Sprachtranskript
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
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
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
talked about 2 topics based on local social activities with some areas of functionality and performance and go for mission-critical 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
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
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 one-third 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
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
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
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
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
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
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
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
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
talked about this OK so the
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
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
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
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
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
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
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
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
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 creep-resistant 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
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
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
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
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
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 mission-critical systems from
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
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
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
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
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
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
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 know-how so alleviation all this promise to be known as the sharing of buying misstated collection built a website so this
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
also understand so some of the Christian faith idea so the next so
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
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
so that's so as to miss out on the 9th and by missing idea so that's FIL so we
engage so 5 up the get evolution so 3 points so that's always
source sink is very much in a truth
Offene Menge
Managementinformationssystem
Kraftfahrzeugmechatroniker
Orientierung <Mathematik>
Dicke
Open Source
t-Test
Mailing-Liste
Oval
Information
Kombinatorische Gruppentheorie
Computeranimation
RFID
Metropolitan area network
Selbst organisierendes System
Bildschirmmaske
Forcing
Software
Spieltheorie
Information
Unternehmensarchitektur
Partitionsfunktion
Offene Menge
Inferenzmaschine
Zahlenbereich
Computeranimation
Metropolitan area network
Geschlossenes System
Software
Standardabweichung
Flächeninhalt
Biprodukt
Auswahlaxiom
Gammafunktion
Tabelle <Informatik>
Inklusion <Mathematik>
Interpretierer
Parametersystem
Lineares Funktional
Distributionstheorie
Transportproblem
Geschlossenes System
Singularität <Mathematik>
Abfrage
Elektronische Publikation
Arithmetisch-logische Einheit
Strahlensätze
Flächeninhalt
Unternehmensarchitektur
Tabelle <Informatik>
Aggregatzustand
Softwaretest
Punkt
Sondierung
Division
Verzweigendes Programm
Kartesische Koordinaten
Kombinatorische Gruppentheorie
Elektronische Publikation
Computeranimation
RFID
Metropolitan area network
Systemprogrammierung
Geschlossenes System
Mereologie
Basisvektor
Mustersprache
Speicherabzug
Schreib-Lese-Kopf
Partitionsfunktion
Impuls
Telekommunikation
Dokumentenserver
Gruppenoperation
E-Mail
Extrempunkt
Gesetz <Physik>
Computeranimation
Task
Metropolitan area network
Message-Passing
Zeitreihenanalyse
Geschlossenes System
Endogene Variable
Modelltheorie
Zeitstempel
Gruppoid
Gammafunktion
Tabelle <Informatik>
Beobachtungsstudie
Open Source
Datenhaltung
Routing
Quellcode
Zeiger <Informatik>
Frequenz
Frequenz
Packprogramm
Web log
Portscanner
Datenfeld
Flächeninhalt
Mereologie
Normalspannung
Partitionsfunktion
Vektorpotenzial
Division
Datenhaltung
Relativitätstheorie
Datenmodell
Verzweigendes Programm
Zahlenbereich
Abfrage
Kartesische Koordinaten
Partitionsfunktion
Gesetz <Physik>
Physikalische Theorie
Computeranimation
Portscanner
Metropolitan area network
Einheit <Mathematik>
Forcing
Endliche Menge
Schwebung
Endlicher Graph
Mustersprache
Mereologie
Datentyp
Ablöseblase
Stochastische Abhängigkeit
Partitionsfunktion
Videospiel
Gewichtete Summe
Punkt
Leistungsbewertung
Zahlenbereich
Strömungsrichtung
Kartesische Koordinaten
Schlussregel
Quellcode
Partitionsfunktion
Gesetz <Physik>
Ereignishorizont
Computeranimation
Videokonferenz
Metropolitan area network
Zeitreihenanalyse
Endlicher Graph
Mustersprache
Endogene Variable
Mereologie
Gammafunktion
Leistung <Physik>
Partitionsfunktion
Leistungsbewertung
Gruppenkeim
Zahlenbereich
Extrempunkt
Computeranimation
Metropolitan area network
Biprodukt
Gruppoid
Modelltheorie
Tabelle <Informatik>
Lineares Funktional
Nichtlinearer Operator
Addition
Distributionstheorie
Logarithmus
Singularität <Mathematik>
Systemaufruf
Abfrage
Schlussregel
Paarvergleich
Biprodukt
Bitrate
Knoten <Statik>
Programmfehler
Bellmansches Optimalitätsprinzip
Mustersprache
Funktion <Mathematik>
Rechter Winkel
Komponente <Software>
Mereologie
Overhead <Kommunikationstechnik>
Modelltheorie
Compiler
Einfügungsdämpfung
Tabelle <Informatik>
Distributionstheorie
Einfügungsdämpfung
Prozess <Physik>
Gruppenkeim
Befehl <Informatik>
Computeranimation
Metropolitan area network
Softwaretest
Gerade
Softwaretest
Caching
Lineares Funktional
Distributionstheorie
Befehl <Informatik>
Sichtenkonzept
Physikalischer Effekt
Systemidentifikation
Quellcode
Speicherbereichsnetzwerk
Entscheidungstheorie
Funktion <Mathematik>
Benutzerschnittstellenverwaltungssystem
Rechter Winkel
Datenerfassung
Schlüsselverwaltung
Aggregatzustand
Partitionsfunktion
Server
System Dynamics
Quader
Ikosaeder
Broadcastingverfahren
Hydrostatik
Task
Bildschirmmaske
Distributivgesetz
Informationsüberlastung
Datentyp
Modelltheorie
Implementierung
Tabelle <Informatik>
Gerichtete Menge
Schlussregel
Partitionsfunktion
Fokalpunkt
Ausgleichsrechnung
Quick-Sort
Einfache Genauigkeit
Flächeninhalt
Hypermedia
Mereologie
Einfügungsdämpfung
Caching
Distributionstheorie
Parametersystem
Lineares Funktional
Distributionstheorie
Partitionsfunktion
Server
Gerichtete Menge
Punkt
Quellcode
Oval
Analysis
Computeranimation
Portscanner
Metropolitan area network
Softwaretest
Funktion <Mathematik>
Rechter Winkel
Konstante
Bitrate
Einfügungsdämpfung
Implementierung
Partitionsfunktion
Punkt
Klasse <Mathematik>
Zahlenbereich
Analysis
Computeranimation
Metropolitan area network
Softwaretest
Konstante
Optimierung
Gammafunktion
Tabelle <Informatik>
Caching
Lineares Funktional
Addition
Distributionstheorie
Call Center
Reihe
Abfrage
Schlussregel
Bitrate
Biprodukt
Partitionsfunktion
Endlicher Graph
Portscanner
Funktion <Mathematik>
Mereologie
Bitrate
Einfügungsdämpfung
Aggregatzustand
Tabelle <Informatik>
Tabelle <Informatik>
Resultante
Partitionsfunktion
Lineares Funktional
Addition
Punkt
Zahlenbereich
Kartesische Koordinaten
Schlussregel
Kinematik
Extrempunkt
Computeranimation
Einfache Genauigkeit
Endlicher Graph
Portscanner
Menge
Geschlossenes System
Mereologie
Zoom
Optimierung
Figurierte Zahl
Partitionsfunktion
TVD-Verfahren
Distributionstheorie
Einfügungsdämpfung
Prozess <Physik>
System Dynamics
Punkt
Leistungsbewertung
Atomarität <Informatik>
Befehl <Informatik>
Analysis
Computeranimation
Metropolitan area network
Multiplikation
Zeitreihenanalyse
Mustersprache
Indexberechnung
Widerspruchsfreiheit
Gammafunktion
Implementierung
Analysis
Tabelle <Informatik>
Caching
Softwaretest
Distributionstheorie
Lineares Funktional
Zentrische Streckung
Geschlossenes System
Befehl <Informatik>
Singularität <Mathematik>
Abfrage
Partitionsfunktion
Ordnungsreduktion
Portscanner
Objekt <Kategorie>
Funktion <Mathematik>
Mereologie
Unternehmensarchitektur
Einfügungsdämpfung
Tabelle <Informatik>
Partitionsfunktion
Distributionstheorie
Punkt
Wasserdampftafel
t-Test
Befehl <Informatik>
Zahlensystem
Term
Binärcode
Computeranimation
Mailing-Liste
Domain-Name
Spannweite <Stochastik>
Distributivgesetz
Wurzel <Mathematik>
Datenstruktur
Phasenumwandlung
Autorisierung
Tabelle <Informatik>
Binärcode
Distributionstheorie
Kraftfahrzeugmechatroniker
Addition
Lineares Funktional
Transinformation
Physikalischer Effekt
Bitrate
Portscanner
Funktion <Mathematik>
Flächeninhalt
Offene Menge
Rechter Winkel
Mereologie
Informationssystem
Tabelle <Informatik>
Nichtlinearer Operator
Geschlossenes System
Punkt
Inferenz <Künstliche Intelligenz>
Stab
Datenhaltung
Zellularer Automat
Frequenz
Bitrate
Biprodukt
Ereignishorizont
Computeranimation
Metropolitan area network
Bildschirmmaske
Bereichsschätzung
Geschlossenes System
Code
Total <Mathematik>
Stichprobenumfang
Gruppoid
Indexberechnung
Ereignishorizont
Unternehmensarchitektur
Dienst <Informatik>
Identitätsverwaltung
Information
Dichtematrix
Datensicherung
Computeranimation
Data Mining
Metropolitan area network
Bildschirmmaske
Einheit <Mathematik>
Geschlossenes System
Software
Endogene Variable
Coprozessor
Indexberechnung
Gruppoid
Inklusion <Mathematik>
Physikalischer Effekt
Nichtlinearer Operator
Geschlossenes System
Schießverfahren
Datenhaltung
Computersicherheit
Logarithmus
Systemaufruf
Konfiguration <Informatik>
Information
Aggregatzustand
Geschlossenes System
Statistik
Web Site
Bit
Schlussregel
Computeranimation
Endogene Variable
Gruppenoperation
Endlicher Graph
Data Mining
W3C-Standard
Message-Passing
Geschlossenes System
Code
Normalvektor
Ext-Funktor
Gammafunktion
Schnittstelle
Server
Einfügungsdämpfung
Bit
Prozess <Physik>
Multiplikation
Verklemmung
Rahmenproblem
Zellularer Automat
Befehl <Informatik>
Computeranimation
Wiederherstellung <Informatik>
W3C-Standard
Message-Passing
Einheit <Mathematik>
Code
Stichprobenumfang
Expertensystem
Softwaretest
Physikalischer Effekt
Geschlossenes System
Physikalischer Effekt
Singularität <Mathematik>
Knoten <Statik>
Rechenschieber
Mustersprache
Mereologie
Hypermedia
Fehlermeldung
Fuzzy-Logik
Kategorie <Mathematik>
Logarithmus
Singularität <Mathematik>
Regulärer Ausdruck
Zahlenbereich
Übergang
Quellcode
Extrempunkt
Variable
Computeranimation
Portscanner
Mustersprache
Message-Passing
Arithmetischer Ausdruck
Funktion <Mathematik>
Konditionszahl
Code
Mereologie
Stichprobenumfang
Mixed Reality
Datenfluss
Message-Passing
Funktion <Mathematik>
Fehlermeldung
Bit
Punkt
Gemeinsamer Speicher
Regulärer Ausdruck
Extrempunkt
Computeranimation
Task
Message-Passing
Gruppoid
Optimierung
Ideal <Mathematik>
Physikalischer Effekt
Nichtlinearer Operator
Geschlossenes System
Open Source
Logarithmus
Eindeutigkeit
Web Site
Mailing-Liste
Übergang
Quellcode
Knoten <Statik>
Gruppenoperation
Portscanner
Mustersprache
Generator <Informatik>
Funktion <Mathematik>
Komponente <Software>
Mereologie
Datenfluss
Message-Passing
Warteschlange
Tabelle <Informatik>
Message-Passing
Elektronische Publikation
Konditionszahl
Client
Annulator
ROM <Informatik>
Computeranimation
Modul
Gruppenoperation
Wiederherstellung <Informatik>
Nebenbedingung
Server
Punkt
Computeranimation
Metropolitan area network
Message-Passing
Gewicht <Mathematik>
Front-End <Software>
Code
Polstelle
Inhalt <Mathematik>
Datenstruktur
Schnitt <Graphentheorie>
Gerade
Varianz
Gammafunktion
Konkordanz <Mathematik>
Kraftfahrzeugmechatroniker
Elektronische Publikation
Güte der Anpassung
Paarvergleich
Quellcode
Objektklasse
Gerade
Diagramm
Funktion <Mathematik>
Client
Translation <Mathematik>
Bitrate
Message-Passing
Fehlermeldung
Physikalischer Effekt
Geschlossenes System
Punkt
Datentyp
Zeitabhängigkeit
Logarithmus
Expandierender Graph
Quellcode
Knoten <Statik>
Gerichteter Graph
Computeranimation
Endogene Variable
Zeichenkette
Software
Message-Passing
Endlicher Graph
Evolute
Gruppoid
Datenfluss

Metadaten

Formale Metadaten

Titel Improving PostgreSQL for Greater Enterprise Adoption
Serientitel PGCon 2015
Anzahl der Teile 29
Autor Sakata, Tetsuo
Enomoto, Yurie
Mitwirkende Crunchy Data Solutions (Support)
Lizenz CC-Namensnennung - Weitergabe unter gleichen Bedingungen 3.0 Unported:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen und nicht-kommerziellen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen und das Werk bzw. diesen Inhalt auch in veränderter Form nur unter den Bedingungen dieser Lizenz weitergeben.
DOI 10.5446/19125
Herausgeber PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Erscheinungsjahr 2015
Sprache Englisch
Produktionsort Ottawa, Canada

Technische Metadaten

Dauer 45:32

Inhaltliche Metadaten

Fachgebiet Informatik
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.

Zugehöriges Material

Ähnliche Filme

Loading...