How does PostgreSQL work with disks: a DBA’s checklist in detail
Presented by:
Ilya Kosmodemiansky
Ilya is a co-founder and CEO at Data Egret (former PostgreSQL-Consulting). His previous experience encompasses such commercial databases as Oracle and DB2. Currently, Ilya works primarily with PostgreSQL with a focus on its performance and effective use in production. He sees the mission of PostgreSQL in substituting the commercial databases in high-performance mission-critical applications.
No video of the event yet, sorry!
PostgreSQL like any other classical database interacts with disks heavily and has dozens of disk-related settings. In order to keep an instance up and running under even moderate workloads, an average DBA needs to dig through PostgreSQL documentation, operating system documentation, hardware vendor manuals, a few books, plenty of blog posts, [HACKERS] and [PERFORM] mail lists archive and finally gain a couple years of experience. This talk will guide DBAs through a checklist, that allows to maximize the disk performance of a PostgreSQL installations. I will concisely summarize typical DBA tasks on four levels: choosing and setting up hardware, operating system configuration, file system mounting with proper options, and PostgreSQL tuning itself. The talk will include but is not limited to such important topics as monitoring I/O-related metrics, checkpoint tuning, autovacuum tuning.
- Date:
- Duration:
- 30 min
- Room:
- Conference:
- PGConf US 2015 [PgConf.US]
- Language:
- Track:
- Admin
- Difficulty:
- Medium