In December, Fujitsu made available a video of Gavin Sherry speaking on Advanced PostgreSQL. (Where's part 2, guys?) Here's some of the topics Gavin addresses, and the approximate point at which they can be found in the video.
- [start]
- wal_buffers: "at least 64"; when it's ok to turn fsync off [not very often]; how hard disk rpm limits write-based transaction rate, even with WAL
- 00:12:
- wal_sync_method = fdatasync is worth checking out on Linux
- 00:13:
- FSM [free space map], MVCC, and vacuum; how to determine appropriate FSM size; why this is important to avoid VACUUM FULL
- 00:22:
- vaccum_cost_delay
- 00:26:
- background writer
- 00:30:
- history of buffer replacement strategies
- 00:37:
- scenarios where bgwriter is not useful
- 00:41:
- how random_page_cost affects planner's use of indexes
- 00:47:
- effective_cache_size
- 00:49:
- logging; how to configure syslog to not hose your performance
- 00:52:
- linux file system configuration
- 00:58:
- solaris fs config
- 1:02:
- raid; reliability; sata/scsi; battery-backed cache ("for $100, you can triple the write throughput of your system")
- 1:08:
- tablespaces
- 1:12:
- increasing pgsql_tmp performance for queries that exceed work_mem and how to tell if this is worth worrying about
- 1:15:40
- cpu considerations
Comments