Monday, January 15, 2007

Abstract of "Advanced PostgreSQL, part 1"

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

No comments: