Bestand wählen
Merken

Introducing PostgreSQL Enterprise Consortium activities

Zitierlink des Filmsegments
Embed Code

Automatisierte Medienanalyse

Beta
Erkannte Entitäten
Sprachtranskript
is and the right consortium this talk will will be done by me and and and just so that was the 1st approach I would give a talk about the achievements of and working group 1 so my name in the cut so he she had the involving in posters development in the region for which is 1 of the forces of the clustering 2 of 4 years and then also I'm looking for this are always says things than OK there was a little so anyway
PostgreSQL and the response of the and answer ensure PG class is but it is organized by reading on the companies in Japan last year which is a neat aims are promoting prosperous in production use and forwards the example this mystery in mission critical area in the 1st year of the BT corn so we had to working groups of which the the Working Group 1 and working to that we published this year the 1st corroborated achievement with was users in and that it was a member companies so we have the review mining and everything to so that would be 1 focuses on a whole months of phosphorus and then replication of precedence so there's while that would be to focus is on migration from other variants especially or and this yourself so we have at this point they had uh sort 9 company members here you can see uh some of the company's here you
there are 2 major activities all PG course so the first one is corroborated verification on pj cost the performance the variation on corroborate theory led to provide the necessary information to help us with the user and then we hope the information is very useful for all of us because of was rests on user not only limited to our cooperative members the 2nd 1 is that and promoting was some of you might know post this is already and quite popular in Japan and properties of the countries outside Japan how about we do not this is what we have with 3 minutes room to make of popular in Japan and also so we can do a song promoting activities including the same and and so on you can see in this picture which is taken from the conference the danger of them in equation so all of Greece take a regret that will be used along with its here we use
OK and I'm going to talk about the of the Arctic these are selected hand throughout discussion here and here I was a member of the area which is of concern about the possible risk come from neighbouring Stockholm high variability them at maintainability some stability security of compatibility and kind of it other entity that there too much work activities for the 1st year even we have a lot of what the companies so through the discussion we have chosen some of them especially personal on performance of activities so and these are people who lost their area from science however these are also divided into some areas of wholeness old as therapists they're about performance-enhancing and performance tuning and the finally we decided to do studies about the splitting up and stand up it is
here is a more detailed description of about suppose that review you what the 1st is the scale of the problem civilization I especially we think there is in many equal machines solvers bodies and 3 variables so at this point and phosphorus so stable budget 9 point 2 and then we are very interested in how it performs well formed these many promotion so we have not done to this the first one is only the query benchmark using PG events it's other that is of the TPC but they seem to fight the PCR test on the on line today shouldn't to coordinated JDBC land In the 2nd period is the spirit of in this area we are using and no single mother singles about 1 up to pull some us in consisting of processing system then model where we have been just the 3 of different the software that 1st 1 is a plus Chris is said president of the might of this 1 has a lot of mass of functionality there called pass that interpretation which is sort of asynchronous certification system the 2nd 1 is media pool to all this is that are adapted for posters and they can be a hormone saying Grossman repetition and then this so software there is what can be done in a long lasting qualitative variance and the problem is most residents C and this is based on the reporting on Japan in Egypt also and then the main feature of these sources of data distribution and then this could be due a to build allows them for like curious on is the quality of the is there is a hand here is that there may have a major they don't call him over here or not you but you know you you you you you will need to know so that was the
1st of these guys here we have enough that we have negative achievements we created the when looking at which is all well a 70 pages and this 1 the Inca they're also began to get over the bridge maps and and the way to the you produce the testing and then all of these looking at account this 30 minutes and then be used by Open Source license CC this document looks like this but unfortunately the against the of this form and this 1 is sort of come on the readings in Japanese I hope someday come this this book of variable in in english OK
there was 1 is a scary problem as version of icons as I have already said we tested through the variational are booked evaluations of source person that is the 1st 1 is done by a very simple 1 RPG bench and then we evaluated the test on the people of machine and then the summary we call 1 of that the posters stairs up to 8 80 crying at 48 periods and
this is a very deep there's always a a and unfortunately I don't have enough time now to explain the data do we do about this sole property that you take a look at the slides on the PGA the website will follow the PGA the constant you can still be there was a strong and this century we have too machines monies for all of these events prior and the other is of course it was some of us are aware of what's Chris is running on this 1 is that there could be a huge solver and the cost of higher as many of the 2 terabytes of memory
on this 1 because was great for these events that these events come out on special script so we have created a special on of new query studies why you might do we do not use of the PostScript there's scenario the dimension is that of the default scenario the is a true susceptible to make lord of all of the solvent so we see decided to create a custom script to the on of natural ruled this is the result
of graph the the white it's this is fact the 2 pass it on in the x axis is the number of concurrent clients the events see them so performance was that according to the a number of prior and they're at the at this point which is exactly the same as the number of a key there we go to amassed maximum performance here we are very pleased about some of the subtleties testing and the 2nd step
problem civilization is using the JDBC than unknown which is different from the 1st on the exact and this 1 does not only did query that like the very baby she right now is essentially a very simple surprised see also has to be sitting scenario
so all of this is the real so a tested at this time that we like axis gives up on find that shows how we need to massacre gate and then it picks up since the is a number of complex systems and the PCC and consists of several different major missile new although they manage their borders status and so and this is the kind of restoration of all of them consumer on course you must setting site on the web so I didn't see and again and the number of of Interpol must is there was going up according to the number of converts sessions like here
is that right out all CPU utilization when we use for the course the direct side is the sum of the CPU utilization is at most of 50 per cent and then the last thing is the grandson of the CPU utilization so we have a tremendous growth in the United States you in the eye distance from this does not necessarily mean that this thing on other this indicates that and there are also the other there are 2 major enhancements I
here and this this July as you can see almost 100 % is if that I will use the occasion and also so that this means that there might be there there is a possible bottlenecks we buy all In this test that impact of some we use the people was awarded the same that is exactly the same tests as well but we can't couldn't get any argued that so we hope that the rests on we warehouse unilaterally I access and we will be able to get there are a number of people in the courts the next 1
is as good about the variation as the 1st description of the evaluation is full of squares cascading reputation In this test but we do like to check that the whole muscle must be performance and because it is critical in this in this processing system and that must go on the whole as well you and then in other reason we call well that must very powerful is stable and even if the number of rate in Greece that this is
in the nation all although of the words model right here we have a typical it's in this you know this we have must be there is a real reason cost savings that someone and then the company has a number of factories that each factory as is done by some of us so the length made this summer and what are some of the sorts information will be provided from the hierarchical dopiest provisions system so I in this this we are focusing on the light the problem there'd be he that these number of up there is a growing and the and the next stated that of governments when the die and there will be a program
but this is after all this system there is a events crime which approach the loss of the present system and the most of the the risk of things that some of which are which has expanded storage and then there are up to post on myself that they have their own range but this
is only the Jose variation here is that the the y-axis is the peak is in the x axis is the number of all some most of us as you can see and performance is very stable even if the number of customers have as the number is growing and that you can see also wanted to see that the here and all must die you can see on their from and then this is the case for all want somebody to somebody and so there are almost the same so now we can conclude that the the Shia political muscle mass and only very stable you would if the number of increase
OK next step out the violation is appreciable true of into a true in summary we can do this 0 it's out of 4 right here local it decreases as the number of nodes increases while story the current and integrating it increases by the number of nodes increases
here is the system for this rotting digital to we we have all of these events crying and it's connected to that the you to imputable to duplicates of current chlorine to the post with system and that we tested you for all the combinations and in this case the performance is defined as the total of all of its PG bench PPPs OK
got here is that you have to look like period I gave lot like axis is the number of production and process them in that like its axis is the number of nodes nodes and then right is told that the period of from the true events other than C. also known note number of nodes degree increases the TPS decreases decreases gravity and the degree 1 is other areas T-PAS for each node you but here is the
that's not good is that will be the query that this is very different from the previous 1 and as the number of nodes decreases by increasing the and that almost immediately increasing so we can say that the total Tapia's increase of the number of nodes increases as the other levels of people to scare is out of all of the OK
and the last 1 it is post respects the see the summary we can we get a good view alright periods as the number of moles increases and subtle took increases the 2nd 1 is full related query by this 1 this and we are given a comment from Mr. quit as gorgeous a piece of it seems that there is a greater problem was it only increases when the size Rogers unwilling to tell that it is there but this
is a benchmark system for for posters and see this is very similar to the previous but this thing is that we have a number all of these units prior and there was we have to hold respects nose but I do know that yeah we suppose chrissakes C has anybody like OK I have and so on I'm going to give us a small exploration about about how plasticity exceed these consistent the sample was posted C it is consistent with the 3 major components of the money's coordinator and the other is that the proposal we have the air quantity and approach according to that is responsible for accepting connections from and distributed to get the and better is is the study of modified ability on of course this of course which is adapting to distribute processing and there are some GT and the date that is responsible for global the other side the management and that they can proxy is a proxy for GP and so in this competition we have coordinated their down on the energy can receive for each node on this money it's not computation of specific OK and this
is like period is desire of the against the other numbers all nodes increases increases the total previously used increases soul to this is very very good example of alright and queries but please note that basic basic plus the system we also all of the likelihood that increases carries out of the wall posts 60 see and we have also no such a system which is like the scary so I'm going to see here this result so this is the
the the theory which I can give you some performance increases as the number of nodes so all so what this is good but how when we call on the
other performance of these of a single generic was stressed very good curatable velocities and that's the same as the of course this will allow some classes in so agreed upon various supposed so she had I get a comment from the college of the company on and all of this is that we we have can to do this is you have to have in the use of the system to the user the figure this is the 1st thing that we used to have a little bit of the whole thing the this is the 1st thing you think of it this as as 1 of of the most interesting you have to do with you need to know of so what we think of it as a work of art the goal of the of the of the University of all the way to the beginning of the end of the year we have a really great and the the the the view of the this is the beginning of the end of the day and it has to do with it so you you you you you you you you you you you you you you you you OK thank you for the comment on the part of the G costly continues all of this kind of activity in this year and on what we hope to a barrier do the wire the variational including oppose visits seem to get in there are a number of people Mr. points as a a deep appreciation us OK this is joint work with the but in this case of thinking you what is the issue of violence put into so all kinds of means on whether there 2 knows that each has 7 point why did you go there and then if there are and also this say point C was was indeed 42 channels OK OK the soul and
these are the of all activities of the home environment there was you 1 thing that I wasn't aware so that's 1 what was scalable scale up the variation on the final and there are already on the default and the writing of the CPU scalability which I need testing was done from with a 64 costs of what we have done that this before 18 costs and then we have increased the release of phosphorus made agrarian CPU scary the 2nd 1 is the square of the operation that we tested the concert cascading application people to impose critics see each has showed that they did you find characteristic carefully as noted custody people stable or like optical mouse even if the number of nodes increases that people told us seems to be strong in and made a query and then was this 60 that seems to be something like periods so we we have observed data different characteristics of these processes across so I mean right through the post refusal to choose like receiving system for fear of and depending on their own pockets OK and that's it for them in the middle not only just moment I need to come to my Michael forms to him you this will go it as thank you for joining this book and I missed at any from NTT tended to have an article about this stage the end of this talk about the achievement of the possible and the Working Group of the sequence periodicity
Isildur agenda and faster than I can write a book about how we decide that they are not altered by the Working Group and the 2nd 1 I will talk about the details of each and the study topics into and finally I will conclude my talk and by the by giving some not appear
as a as the Chairman of us upon the Working Group is the game is minded migration and I'd like to talk about how we decide stand
and this ratio the idea that all of the articles with a questionnaire and you know of these equals openings and and the question was which indigenous are you using the topic of the talk a world and the counties maybe 46 the 2nd is opposed to this and the company's 31 and the size of is scarce Hubble under my thinking and the content of these 16 each and for angles and user identity the and the company's 6 and there and there and there is only 1 possible use the site what is the point is you is that the uses all Oracle DB skills of the site is under my signal by in total 2 . 2 5 times more than those of force and look at those as a system as they may be made easier and the present so that we must talk with those and indigenous so I
think the question is why we choose a by this and other tales 2002 at the working for and that was the answer now to other out interbred users using other deviance tuples and so the no migration nor enterprise and this is also
and this latest shows the report of kind looking it is the thing that includes database migration guidance of area and power migration entirely this talk medicine was up to 100 pages and it is still going this year and if the plant is open to the public in PG put the website OK
and now I would like to go on to the highlighted from and a wanting to people the people is
organized the easy part and the fast block is training the migration physics and this includes database migration from and the 2nd part includes the study of each migration persist and this includes an system architecture and cooperating database systems and is scared migration stored procedure and built-in function migration and application migration the sun is addicted to play a meaningful to all my visual this includes and research in data migration and properties and the fructose of obligation migration
OK the hostility is Debian is migration from and the study in the studies and the studies of running the DBM as migration processes to to post this on this aim is to establish and the Colombo grumbled migration processes to to us and it is an experience it is an idiot explained other than total DBMS my vision and dismayed issued the ability to do on that which the and the 2nd peak
is and there is and system architectures the dedicated efforts have been investigated by major database system architectures and deployed on information to find the correspondence posted these major ideas and that of a system architectures a single cell of the higher the higher the deepest and the occasional and and knowledge must know the velocity and the points to need to consider the and the various migration high variability and you don't need on the right performances and extensibility Easy to design will use it to operate and the initial cost and they didn't provide the details of the people on the the human the next topic is
according to the database systems the focal so although database Corporation and at is statewide migration of Complex Systems Research Group there is and all the deduction of most of the and the evaluation of the full disaster and the size of the data warehouse systems and then the dedicated something dedicated something's investigate some software for generating energy efficiency in different begins and that includes evil framework and the coordinator instance the model or the prime and the rest by the sum of his style of and this will end up then exceedingly of all and the the
next topic in is about the scale migration gains a dedicated to something the investigated a schema of cortical and opposed to this and they also studied some money and intervention points using Web 2 PCs it to In binary it's a point 5 was 1 of those tableful eating data types ended and mining to migrate to scheme and this slide shows the plot of was from the stable and the this side is in a the world of items and in the next slide the correspondence was the worst correspondence 1
the next is scary migration and I think there's something to investigate is scared compatibility of water this crucible and a possibly and they also compare come under the table and the guide In this slide this slide so that the part of it complies table the 1st items and and then that's the book and the 1st i parts vitamins grows and the table said that could also be in DBMS has we schools and the 2nd 1 the other 1 is distinct and again and the tables said also the house also these have been a had and this other 1 in the end you need the table said that you need these work with specific on the contrary the force along the the top grows and the top quality is the scarce the statistics and and so on and the revised and and detail detail in the human are the next
topic is stored procedures migration for optimal start procedure is impossible to verify the magnitude of the and the study in this part of the study in this field indicates concluded that in some sort of procedure can be translated all about however if it is very difficult to migrate before the procedure is involving semantics and and the full cost of viewpoint and in for some stored procedure it is much better to active to applications rejects and and to form but attempted in corresponding as tho the functions the next topic is
a built-in function migration the something investigated the function and difference between Oracle and opposed to this day also compiled a built-in function complacently and decide plot this despite this is the part of the table all that is to say this that is designed so that the work of function items on the right right side here is shown here so the input so this sticky buttons and for the 1st the 1st item and these are the ones that the tables the table describes how how you can achieve an oracle and must given as input to this and fossil for some of the Jedi Council and at table C is an additional was 1 interest of this whole thing to the the 10th and they provide the details in the rest of the condition so
at now I I directed the ball into side of the track the faster the of plan is the data and the subgame studied in the collaboration process from other DBMS to and the process and the houses and the process houses the people it's a except for a transform fault and and input and the 1st part an extract of from other the 1st book it's not there from other units and it will look at it in Sicily fire in this in this type of sentence what do is local 1 of the 2nd farm the man and about the problem and it's not about and transform the the it status of the fire until it was too in order for and this thought that for some of the characters attract accordingly composer and it is said that about building products encloses the current does it take to that data and they also look right the acquired information did not know how to do optical members OK
to find up and final and took is application migration to and the sub-team upright acquired information the novel at the time of migration from all the practical application of other DBMS to customers and 9 . 2 . 2 and the migration target application with his name the command of which it is open source and the general idea or sorry is open for the general obligation to create about what the relevance the demands on oracle and this goes along the bicycle and but then it did not ground you only to and the application side isn't so many well so that the states and the number of tables or the number of tables is 39 the number will escape statement is was a 6 of and then directly in the original study precision
this is a very utilized to to accept necessary modification put in a scarcity In the name of tool is syntax the decisions of migration aid to from Oracle embarrassed to post and the end it is open source software developed by devices is the customers of versus it is available in the Tulsa it is to provide an incentive different dictionaries and operates at part I marching along in skill programs and dictionary we think it's dictionary into this article in the expression the expression for and therefore it is user-customizable and the
migration process is as follows so fast and they operate of migration to the deletion text this to be jealous sources jobless source a schema the deer and the date of Indian act then they modified and according to how all of legitimacy derivatives after that they modify it scares determined according to the recent of this and the finally indicators and the basic functionality of in commander Fuji applications you know you
you the conclusion and the conclusion of this prose this and it'll is as follows and more than 90 per cent of the time was spent feel that it is equal and it scared modification was adopted to to utilization of my vision to and all of its constituent was tested in the good result with efficient and that almost all of them but to a well-connected interest can use that in this graph indicate this yeah so the time consumption this year that year on on the on the test phase and in each time a vessel is a 91 . and 91 . 4 % of the total total process and now I
will I directed at fulfilling my little buddy and by giving some demands and the data about the inclusion criteria for a successful migration from that provision
fast 1st of water quality is successful motivation even the system itself operates and start reading for so this is another a synthesis this is the membership of the ends up with very few so a successful migration we consider is motivation for his final cost is very near to the initial this mission
on the slide show that 2 points for successful my mission to post to this we consider the false-alarm is not suitable to a system we considered the initial assessment of this is the most important and to to the assessment of correctly you you need to understand and activities of very also what you know systems and the decline of my way to the new system you also need to understand I predicting the difference between the origin of the Guinness and possible and you also you find finally it you need to utilize and migration needed to is the reverse then the 2nd the point is is that you need to prepare a distinct and substantive after all of those works tend to be included and it's the nerve that trial was on 90 per cent of the time is spent in test phase so modification well there was there was saying using migration to the but the tools that are not perfect so you need to prepare a full minor modification of and that
is the end of my talk in the In addition to to the middle of the parameters of the of the of the of the of the the set of all this his her her her her her her her her with the grammar of the half of the that has just like that from that I wasn't too often that question is no need to have it it into the and the communication is provided to invite native peoples and this and and it should be in the tasks of scene in Times think it might utility have it it it depends on the time we have so in a distant milk it is it a the theory is she said pretty pretty the following this is going be this is for individual was this uses for the 1st time that there was asked where is equals the use of members of the corporation and so on and I think that we really want to buy popcorn not talk on the activities of the different unintelligible and this is 1 of the most noble and just
focus on very similar to other and you groups in the in the
words of 1 of these in the
course is very unique I don't think that we have a similar
all individuals in the last year so general and there's no on so I believe we we count on the blood of the necessary because the to promote posters in Japan due to the older individuals that are actually and we have to join the Conference on all of the the ones part of once and then give a constant so in this about 1 directory of maker of course where the log of the colleges part of as well so the sum of any of these 2 0 but in this town of corporate each other but this this also on the list of the focus on the local OK so that
Unternehmensarchitektur
Forcing
Gruppentheorie
Softwareentwickler
Schnitt <Graphentheorie>
TVD-Verfahren
Punkt
Kategorie <Mathematik>
Klasse <Mathematik>
Programmverifikation
Gruppenkeim
Programmverifikation
Gleichungssystem
Information
Abstraktionsebene
Biprodukt
Physikalische Theorie
Quick-Sort
Marketinginformationssystem
Computeranimation
Data Mining
Unternehmensarchitektur
Flächeninhalt
Gruppentheorie
Migration <Informatik>
Endogene Variable
Datenreplikation
Flächeninhalt
Information
Retrievalsprache
Distributionstheorie
Domain <Netzwerk>
Stabilitätstheorie <Logik>
Punkt
Leistungsbewertung
Baumechanik
Unternehmensmodell
Computeranimation
Virtuelle Maschine
Variable
TUNIS <Programm>
Charakteristisches Polynom
Maßstab
Software
Gerade
Varianz
Benchmark
Beobachtungsstudie
Softwaretest
Zentrische Streckung
Lineares Funktional
Interpretierer
Digitales Zertifikat
Computersicherheit
Ruhmasse
Abfrage
Benchmark
Physikalisches System
Quellcode
Frequenz
Ereignishorizont
Quick-Sort
Softwarewartung
Differenzkern
Flächeninhalt
Heegaard-Zerlegung
Hypermedia
Lesen <Datenverarbeitung>
Innerer Punkt
Message-Passing
Verkehrsinformation
Signifikanztest
Softwaretest
Retrievalsprache
Explosion <Stochastik>
Leistungsbewertung
Open Source
Virtuelle Maschine
Versionsverwaltung
Bridge <Kommunikationstechnik>
Quellcode
Bildschirmsymbol
Quick-Sort
Computeranimation
Homepage
Mapping <Computergraphik>
Virtuelle Maschine
Bildschirmmaske
Maßstab
Lesen <Datenverarbeitung>
Skript <Programm>
Hardware
Leistungsbewertung
Beobachtungsstudie
Resultante
Web Site
Kategorie <Mathematik>
Leistungsbewertung
Hausdorff-Dimension
Virtuelle Maschine
Abfrage
Ereignishorizont
Computeranimation
Rechenschieber
Virtuelle Maschine
Maßstab
Thread
Zahlenbereich
Festspeicher
Client
Skript <Programm>
Default
Signifikanztest
Explosion <Stochastik>
Punkt
Graph
Extrempunkt
Datenparallelität
Leistungsbewertung
Applet
Zahlenbereich
Benchmark
Baumechanik
Ereignishorizont
Computeranimation
Client
Serielle Schnittstelle
Primzahlzwillinge
Server
Web Site
Umsetzung <Informatik>
Gewichtete Summe
Skalierbarkeit
Softwarewerkzeug
Familie <Mathematik>
Zahlenbereich
Zentraleinheit
Computeranimation
Komplexes System
Benutzerbeteiligung
Verknüpfungsglied
Rechter Winkel
Primzahlzwillinge
Client
Abstand
Zentraleinheit
Transaktionsverwaltung
Familie <Mathematik>
Softwaretest
Signifikanztest
TVD-Verfahren
Prozess <Physik>
Leistungsbewertung
Zahlenbereich
Datenreplikation
Physikalisches System
Bitrate
Computeranimation
Deskriptive Statistik
Quadratzahl
Mini-Disc
Leistungsbewertung
Hierarchie <Mathematik>
Dicke
Einfügungsdämpfung
Leistungsbewertung
Programm
Speicher <Informatik>
Zahlenbereich
Benchmark
Datenreplikation
Physikalisches System
Information
Unternehmensmodell
Ereignishorizont
Quick-Sort
Computeranimation
Physikalisches System
Spannweite <Stochastik>
Unternehmensmodell
Reelle Zahl
Client
Faktor <Algebra>
Wort <Informatik>
Information
Speicher <Informatik>
Schreiben <Datenverarbeitung>
Retrievalsprache
TVD-Verfahren
Knotenmenge
Rechter Winkel
Leistungsbewertung
Lesen <Datenverarbeitung>
Ruhmasse
Zahlenbereich
Kartesische Koordinaten
Datenreplikation
Knotenmenge
Computeranimation
Gravitation
Total <Mathematik>
Prozess <Physik>
Konfigurationsraum
Zahlenbereich
Strömungsrichtung
Kartesische Koordinaten
Datenreplikation
Physikalisches System
Biprodukt
Frequenz
Ereignishorizont
Computeranimation
Physikalisches System
Knotenmenge
Minimalgrad
Flächeninhalt
Rechter Winkel
Schreiben <Datenverarbeitung>
Retrievalsprache
Total <Mathematik>
Sichtenkonzept
Leistungsbewertung
Güte der Anpassung
Zahlenbereich
Abfrage
Frequenz
Knotenmenge
Computeranimation
Übergang
Knotenmenge
Lesen <Datenverarbeitung>
Resultante
Beobachtungsstudie
Retrievalsprache
Chipkarte
Proxy Server
Likelihood-Funktion
Konfigurationsraum
Güte der Anpassung
Abfrage
Zahlenbereich
Physikalisches System
Verteilte Programmierung
Frequenz
Computeranimation
Physikalisches System
Energiedichte
Knotenmenge
Einheit <Mathematik>
Stichprobenumfang
Client
Zusammenhängender Graph
Koordinaten
Benchmark
Geschwindigkeit
Retrievalsprache
Bit
Punkt
Sichtenkonzept
Klasse <Mathematik>
Zahlenbereich
Physikalisches System
Physikalische Theorie
Computeranimation
Arithmetisches Mittel
Knotenmenge
Mereologie
Lesen <Datenverarbeitung>
Figurierte Zahl
Grundraum
Feuchteleitung
TVD-Verfahren
Stabilitätstheorie <Logik>
Folge <Mathematik>
Subtraktion
Momentenproblem
Leistungsbewertung
Skalierbarkeit
Schreiben <Datenverarbeitung>
Zahlenbereich
Kartesische Koordinaten
Technische Optik
Computeranimation
Knotenmenge
Bildschirmmaske
Skalierbarkeit
Default
Signifikanztest
Beobachtungsstudie
Nichtlinearer Operator
Zentrische Streckung
Farbverwaltungssystem
Abfrage
Datenreplikation
Physikalisches System
Migration <Informatik>
Frequenz
Quadratzahl
Charakteristisches Polynom
Programmierumgebung
Zentraleinheit
Web Site
Punkt
Spieltheorie
Winkel
Migration <Informatik>
Nichtunterscheidbarkeit
Inhalt <Mathematik>
Physikalisches System
Computeranimation
Offene Menge
Explosion <Stochastik>
Datenhaltung
n-Tupel
Web Site
Migration <Informatik>
Computeranimation
Homepage
Datenhaltung
Homepage
Unternehmensarchitektur
Flächeninhalt
Migration <Informatik>
Unternehmensarchitektur
Verkehrsinformation
Leistung <Physik>
Beobachtungsstudie
Lineares Funktional
Prozess <Informatik>
Kategorie <Mathematik>
Datenhaltung
Physikalismus
Speicher <Informatik>
Kartesische Koordinaten
Physikalisches System
p-Block
Migration <Informatik>
Algorithmische Programmiersprache
Computeranimation
Datenhaltung
Unternehmensarchitektur
Systemprogrammierung
Physikalisches System
Selbst organisierendes System
Funktion <Mathematik>
Framework <Informatik>
Migration <Informatik>
Mereologie
Unternehmensarchitektur
Beobachtungsstudie
Geschwindigkeit
Server
Prozess <Physik>
Punkt
Zellularer Automat
Summengleichung
Information
Computeranimation
Physikalisches System
Variable
Migration <Informatik>
Punkt
Maßerweiterung
Beobachtungsstudie
Multifunktion
Architektur <Informatik>
Datenhaltung
Datenreplikation
Physikalisches System
Migration <Informatik>
Framework <Informatik>
Rechter Winkel
Multifunktion
Information
Datenfluss
Unternehmensarchitektur
Gewichtete Summe
Punkt
Data-Warehouse-Konzept
Existenzaussage
Orakel <Informatik>
Wirkungsgrad
Unternehmensmodell
Framework <Informatik>
Computeranimation
Datenhaltung
Physikalisches System
Systemprogrammierung
Last
Benutzerbeteiligung
Polarkoordinaten
Software
Migration <Informatik>
Datentyp
Ordnungsreduktion
Leistungsbewertung
Zentrische Streckung
Data-Warehouse-Konzept
Multifunktion
Datenhaltung
Nummerung
Plot <Graphische Darstellung>
Physikalisches System
Migration <Informatik>
Rechenschieber
Software
Komplex <Algebra>
Multifunktion
Beobachtungsstudie
Koordinaten
Instantiierung
Tabelle <Informatik>
Umwandlungsenthalpie
Beobachtungsstudie
Lineares Funktional
Server
Mathematische Logik
Kontrollstruktur
Minimierung
Wasserdampftafel
Speicher <Informatik>
Kartesische Koordinaten
Umsetzung <Informatik>
Migration <Informatik>
Quick-Sort
Algorithmische Programmiersprache
Computeranimation
Rechenschieber
Datenfeld
Funktion <Mathematik>
Forcing
Migration <Informatik>
Mereologie
Elektronischer Programmführer
Größenordnung
Transaktionsverwaltung
Tabelle <Informatik>
Subtraktion
Prozess <Physik>
Automatische Handlungsplanung
Orakel <Informatik>
Transformation <Mathematik>
Information
Computeranimation
Eins
Weg <Topologie>
Einheit <Mathematik>
Migration <Informatik>
Datentyp
Lineares Funktional
Prozess <Informatik>
Plot <Graphische Darstellung>
Ein-Ausgabe
Migration <Informatik>
Kollaboration <Informatik>
Funktion <Mathematik>
Konditionszahl
Mereologie
Information
Beobachtungsstudie
Orakel <Informatik>
Tabelle <Informatik>
Subtraktion
Programm
Zahlenbereich
Kartesische Koordinaten
Orakel <Informatik>
Information
Dialekt
Computeranimation
Open Source
Arithmetischer Ausdruck
Software
Migration <Informatik>
Punkt
Beobachtungsstudie
Befehl <Informatik>
Open Source
Applet
Migration <Informatik>
Data Dictionary
Entscheidungstheorie
Mereologie
Information
Tabelle <Informatik>
Aggregatzustand
Orakel <Informatik>
Softwaretest
Lineares Funktional
Abstimmung <Frequenz>
Prozess <Physik>
Prozess <Informatik>
Graph
Softwarewerkzeug
Befehl <Informatik>
Orakel <Informatik>
Kartesische Koordinaten
Derivation <Algebra>
Quellcode
Migration <Informatik>
Signifikanztest
Computeranimation
Funktion <Mathematik>
Subtraktion
Code
Migration <Informatik>
Gruppoid
Indexberechnung
Maschinelles Sehen
Phasenumwandlung
Physikalisches System
Logiksynthese
Migration <Informatik>
Kegelschnitt
Physikalisches System
Element <Mathematik>
Migration <Informatik>
Inklusion <Mathematik>
Computeranimation
Softwaretest
Addition
Telekommunikation
Parametersystem
Subtraktion
Punkt
Softwarewerkzeug
Formale Grammatik
Physikalisches System
Migration <Informatik>
Physikalische Theorie
Computeranimation
Task
Demoszene <Programmierung>
Rechenschieber
Physikalisches System
Menge
Reverse Engineering
Migration <Informatik>
Punkt
Phasenumwandlung
Gewichtete Summe
Mereologie
Gruppenkeim
Mailing-Liste
Wort <Informatik>
Benutzeroberfläche
Verzeichnisdienst
Fokalpunkt
Chi-Quadrat-Verteilung
Computeranimation
Eins

Metadaten

Formale Metadaten

Titel Introducing PostgreSQL Enterprise Consortium activities
Serientitel PGCon 2013
Anzahl der Teile 25
Autor Hemmi, Hitoshi
Ishii, Tatsuo
Mitwirkende Heroku (Sponsor)
Lizenz CC-Namensnennung - keine kommerzielle Nutzung - 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/19051
Herausgeber PGCon - PostgreSQL Conference for Users and Developers, Andrea Ross
Erscheinungsjahr 2013
Sprache Englisch
Produktionsort Ottawa, Canada

Inhaltliche Metadaten

Fachgebiet Informatik
Abstract PostgreSQL Enterprise Consortium (PGEcons) is a non-profit organization aiming for promoting PostgreSQL in production use, especially in mission critical area. It is formed by leading IT companies in Japan last year. Currently PGECons has 36 company members. In the first fiscal year, PGECons performed two major technical activities: PostgreSQL scale up/scale out evaluation (by Working Group 1: WG1) and establishing migration process from commercial DBMSs to PostgreSQL (by Working Group 2: WG2). These objectives were determined based on requests from PostgreSQL users and PGECons members and PGECons believes that sharing the experience is a big benefit for PostgreSQL community. In this talk we present current achievements of WG1 and WG2. PostgreSQL Enterprise Consortium (PGEcons) is a non-profit organization aiming for promoting PostgreSQL in production use, especially in mission critical area. PGECons performed two major technical activities conducted by two working groups (WG1 and WG2). In this talk we present current achievements of WG1 and WG2. The tests conducted by WG1 fall into two categories: scale up test and scale out test. For scale up test the target was a 80 physical core server to check how PostgreSQL 9.2 behaves against concurrent transactions. We will report the detailed results including the fact that PostgreSQL scales up to 80 concurrent users with read-only load. For the scale out tests, we tested three configurations: PostgreSQL's cascading replication with a master, a cascading standby, and four standbys, pgpool-II running in native replication mode with 4 nodes and Postgres-XC with 4 data nodes. Each configuration showed different characteristics. For example, pgpool-II performed well with read-only load, while Postgres-XC was strong in write load. We will present them with detailed data. To promote adoptions of PostgreSQL in enterprise domain, WG2, Operation and Design working group in official, examined several related issues on the start time and determined to focus on DBMS migration. According to the survey of attendees at PGECons opening seminar, users of Oracle, DB2, SQL Server, Sybase and MySQL are in total 2.5 times more than those of PostgreSQL, even in such a PostgreSQL event. Because many of those utilizations are predicted to be enterprise ones, dealing with them is indispensable for our purpose. In the first fiscal year, WG2, participated by 11 software businesses, carefully studied the DBMS migration process, divided it into 14 subtasks, and started to tackle to 11 of them by dedicated sub-teams. Selective topics from these activities as well as the big picture of WG2 will be presented in this talk.

Ähnliche Filme

Loading...
Feedback