Speaker Interview: Stéphane Schildknecht
Be pro-activ on PostgreSQL performance Tuesday 13:40 Wavel+Syrena
Could you briefly introduce yourself?
I am Stéphane Schildknecht, a long term PostgreSQL enthousiast. After some time having dealt with Oracle, I learned about PostgreSQL at the beginning of the century.
I quickly understood this database would be a major player in the database business.
What's more, I discovered the PostgreSQL community at that time, and once you know it, you can't leave it.
A few years later, with other PostgreSQL enthousiasts, we settled the first non-profit association in France.
Being its president, I saw a major turn in its adoption.
In 2010, I created my own PostgreSQL consulting company, keeping in mind that a broader PostgreSQL adoption is linked to a real professional services offer.
As I did not want to create confusion between my community work and my business, I stepped down from my role in the non-profit organization.
I went on with my other community implications (moderator fo pg_sql-fr-general, french-speaking Europe press contact...).
Have you enjoyed previous pgconf.eu conferences, either as attendee or as speaker?
I couldn't make it to the first european PostgreSQL Conference in Prato. But, since then, I didn't miss any.
From Paris in 2009 to Tallinn last year, and Warsaw this year.
I am also a big fan of pgday.paris.
What will your training be about, exactly? Why this topic?
Lætitia and I will try to convince people that it is quite easy to have an satisfying initial configuration of a PostgreSQL instance before it goes in production, in order to have acceptable performance.
We will then show some tips on how to be confident with its everyday workload. What one should look at, how one can interfere with the instance... to get desirable performance.
Performance is a universal topic. Maybe you don't have performance issue yet, or think you don't. But, you certainly will, some day. And if you have some tips to be prepared, you will remain the everyday hero in your company.
What is the audience for your training?
Well, DBAs, I guess, are the first intedended audience. Sysadmins, also, could get some intersting tips on how to manage performance on a PostgreSQL instance.
What existing knowledge should the attendee have?
The attendee should have an existing production experience, to get faster to the point.
We won't go into much deeper details, but the attendee should have the knowledge of PostgreSQL configuration, how to modify it, some knowledge of SQL and Linux system. 3 hours won't make you an expert, but it may be profitable anyway.