Could you briefly introduce yourself?

I'm Lætitia AVROT. I work with PostgreSQL since 2007. When I became a DBA I first worked with PostgreSQL, and by the end on 2007 I had to work also on Oracle and SQL Server.

As you can't be good in 3 RDBMS at a time, I choose to focus on one. I choose PostgreSQL for several reasons.

- It was my first RDBMS so I might not be completly objective, but it seemed to me that PostgreSQL was more stable and reliable than the other two...

- Then the "open source" thing was a great plus to me. It's quite rare to work in line with your own values. I'm just so happy to have that luck.

- Finally, I found the communauty really friendly and open minded and that's great.

Have you enjoyed previous pgconf.eu conferences, either as attendee or as speaker?

Last time I went to pgconf.eu, it was in 2009 in Paris. I had bought a stuffed Slonik for my (at the time) 1-year old girl. Now that she has a little sister, they're arguing about Slonik's ownership very often so I had to come back to buy another one!

More seriously, since I chose to focus on PostgreSQL, I attented several events. I met there a wonderful girl who became a friend and actually made me realize I might give talks too. So I begun answering calls for papers and... Voilà !

What will your training be about, exactly? Why this topic?

My boss Stéphane and I will be talking about performance. How to focus on performance issues before they become problems? That's what we are going to talk about. We will give some tips about PostgreSQL settings and we will discuss how to solve different kinds of issues.

If you think you don't have any performance issue, I guess you just don't know you have. When a client asks us for help, he's having performance issue more than 9 times out of 10. So we decided to help preventing them!

What is the audience for your training?

Mostly DBAs, but curious developpers and sys admins are welcome too!

What existing knowledge should the attendee have?

Well in 3 hours, we can't explain everything from the begining. So you have to know some basic Linux command lines. If you're allready working with PostgreSQL, I think it will be more comfortable for you, even if we will explain over basic notions.