Let us present you with a digest of the upcoming talks that were announced this week. And one more thing. Many of you showed big interest in our limited T-Shirts, so we decided to bring you the opportunity to get them!
"Blind men probing an elephant: performance engineering and PostgreSQL"
Elephant is the largest mammal on Earth. Tactical and technical capabilities of an elephant allow him not only to serve as a means of destruction of the enemy's infantry and mechanized forces, but also serve as a relational database. Various aspects of that last potential application of the elephant is what we are going to discuss. Which elephant is more effective - the one running under Ubuntu 12.04 or DragonFly BSD 4.0.5? What serves better as a storage - SAS, SSD or hybrid combinations of slow HDDs and fast SSDs? How does the size of a transaction affect performance? Is ZFS really that bad, as Ilya Kosmodemiansky claims it to be? No sorcery, no magic, only slide gauge and oscilloscope.
"Procedural languages for server-side programming in PostgreSQL"
The diversity of server-side programming languages provides great possibilites for development of applied solutions and presents a visible advantage of PostgreSQL over many other RDBMS.
In this talk, we will inspect the internals of procedure languages. We will compare them in terms of functionality (based upon feature matrix) and performance in extreme and moderate cases (lots of data, lots of calculations, "the city test"). Afterwards, we'll attempt to find a explanation for the results we'll receive.
An insane attempt of an alternative PL/pgSQL implementation (only partial, of course) will be undertaken in order to understand how it can be sped up without changing its underlying logic.
We will discuss possibilities of the improvement in performance that could be gained by means of JIT-compilation of SQL queries (and of all server-side code, as well) by looking at the example of VitesseDB.
The next subject of the talk is the PL/Perl language as an example of SQL-like server-side language. What advantages does it have compared to PL/pgSQL and how one have to pay for them? A couple of example from the speaker's experience and guidelines on how to use PL/Perl properly.
In conclusion, we will look at how user-defined data types are supported in procedural language, once again, using PL/Perl as an example, taking into consideration the upcoming features of PostgreSQL 9.5. How to add a new type? We will attempt to implement support for JSON & JSONB in PL/Perl.
This talk is aimed at application programmers who employ PostgreSQL.
"PostgreSQL as a platform for application-level programmers"
Quite often, due to a whole spectrum of reasons (data proximity, performance, platform independence) we want to store not only data, but also the application logic in the database. However, the lack of time-proven best practices for development, absence of libraries and frameworks, archaism-like and inexpressive features of SQL and pl/pgsql prevent many modern programmers from doing so. Would it be possible to change the way the things are? Is it possible to create a comfortable and dynamic ecosystem for application programmers that will allow them to solve their tasks effectively, as well as share their code and experiences? Can PostgreSQL permit to manage not only data, but also the code base in an efficient manner?
Now, regarding the T-shirts...
Selling T-shirts is a complicated matter, so we will give the T-shirts for free to anyone who invites a friend to the conference!
To confirm the invitation, simply send an email to [email protected] with the name of the person who registered at your recommendation. We will consider all those who have registered starting from today.
Subscribe to news and events:
