Database consulting and application development...
...because your data is your business
Nov. 25, 2015
The Accidental DBA
So, you’ve inherited a PostgreSQL server. Congratulations? Thanks to Postgres’ popularity as the database for new applications, both open source and commercial, thousands of developers, system administrators and devops are finding themselves in charge of PostgreSQL servers with no idea what to do next. This tutorial will cover the essential care and feeding of a Postgres elephant so that you can get back to your real job. The tutorial will include the following core topics: Installation Updates and upgrades Backup System information Configuration Basic query troubleshooting Connection management Monitoring Replication basics Where to go for further help.
In 15 minutes, plus Q&A time, Postgres expert Josh Berkus will explain the essentials of making your database performance "good enough" that you can ignore it and move on to other things. This will include: Why database configuration is less than 20% of performance The 14 settings most people need Why connection pooling is essential Avoiding bad hardware DB performance for the public cloud Stupid things your app does which kills performance Enjoy this fast-paced roundup of PostgreSQL performance essentials.
Whatever you use PostgreSQL for, version 9.4, released December 18th, has a lot to offer. Whether you're migrating your NoSQL application to PostgreSQL by using the new JSONB or scaling up using higher performance, scaling out using the new replication API, or doing analytics using new analytic functions. version 9.4 has something for you. Come learn all about it, with demos.
Gentlemen, start your database engines! PostgreSQL 9.2 beta is here, and it's faster and more exciting than ever before. Come down to the track and join us for a high-speed tour of a database which is faster than ever before! Starting at pole position, we will whip around the features of version 9.2, speeding through one demo after another, including: cascading replication enhanced vertical scalability improved performance index-only access range types JSON support better live DDL deployments new administrative views It's the fastest PostgreSQL yet, and you have a shotgun seat!
Firehouse Engineering:Designing high-volume data collection systems
How to best design a system which allows for large amounts of incoming data and a large amount of processing of this data. This talk goes over the 4 biggest issues which must be dealt with: Volume, constant flow, database size and component failure. The talk continues by discussing the ways to solve these problems.