Postrelease
Talks
Talks archive
-
Pavel Stehule freelancer- the architecture
- the design and implementation of PL/pgSQL
- the difference between PL/SQL and PL/pgSQL
- the advantage and issues of PL/pgSQL
-
Teodor Sigaev PostgresPro
Anastasia Lubennikova PostgresPro
Alexander Korotkov PostgresPro -
Vladimir Sitnikov Pgjdbc, JMeter committerCommon Java wisdom is to use PreparedStatements and Batch DML in order to achieve top performance. It turns out one cannot just blindly follow the best practices. In order to get high throughput, you need to understand the specifics of the database in question, and the content of the data.
In the talk we will see how proper usage of PostgreSQL protocol enables high performance operation while fetching and storing the data. We will see how trivial application and/or JDBC driver code changes can result in dramatic performance improvements. We will examine how server-side prepared statements should be activated, and discuss pitfalls of using server-prepared statements.
-
Ivan Goncharov IBMArchitecture features of IBM Power 8 allowing to gain high performance in comparison with x86_64. CPU, memory, IO etc. Experience of real benchmarking.
Photos
Photo archive